SQL · Theory

Difference Between MySQL and PL SQL

Theory

396/439

Difference Between MySQL and PL SQL

SQL is the language (SELECT, INSERT). MySQL is one database product that speaks SQL. Saying ‘I know SQL’ is not the same as ‘I administered MySQL users and dumps’.

You can know SQL and work in Postgres. You can use MySQL and still write bad SQL. Learn both: language + this engine’s types, LIMIT, backticks, AUTO_INCREMENT.

Trap — using them as synonyms in a strict viva.

On the example next to this theory: Difference Between MySQL and PL SQL — wHERE combines predicates with AND/OR; LIKE does pattern match.

Exam tip

SQL language, MySQL product. Postgres also speaks SQL.

Difference Between MySQL and PL SQL — sample query

CREATE TABLE products (id INTEGER PRIMARY KEY, name TEXT, price REAL);
INSERT INTO products VALUES (1, 'Pen', 10), (2, 'Book', 200), (3, 'Bag', 50);
SELECT * FROM products
WHERE price BETWEEN 20 AND 150 AND name LIKE 'B%';

Difference Between MySQL and PL SQL — wHERE combines predicates with AND/OR; LIKE does pattern match.

Short notes

DefSQL = language. MySQL = a server that speaks it.
RuleName both in one sentence.
Trap‘SQL and MySQL are the same’.

CREATE TABLE products (id INTEGER PRIMARY KEY, name TEXT, price REAL); INSERT INTO products VALUES (1, 'Pen', 10), (2, 'Book', 200), (3, 'Bag', 50); SELECT * FROM products WHERE price BETWEEN 20 AND 150 AND name LIKE 'B%';

Difference Between MySQL and PL SQL

Difference Between MySQL and PL SQL — sample query

Short notes

Questions

Difference Between MySQL and PL SQL

Difference Between MySQL and PL SQL — sample query

Short notes

Questions