A syntax error, since FROM is always mandatory

The name of the currently selected database

Sorts by price from highest to lowest, then breaks ties by name alphabetically

INSERT INTO products (id, name, price) VALUES (1, 'Mouse', 9.99);

INSERT INTO products VALUES id=1, name='Mouse', price=9.99;

MySQL inserts NULL into that column anyway

MySQL rejects the insert and raises an error

DELETE FROM customers WHERE country = 'France';

DELETE customers WHERE country IS France;

DELETE FROM customers VALUES country = 'France';

The number of non-NULL values across all columns

One distinct country along with the count of customers in it

It allows attacker-supplied input to change the query's intended logic

It always produces a syntax error before the query can run

It automatically encrypts the stored data

The same table is joined to itself using two different aliases

SELECT dept, COUNT(*) FROM employees GROUP BY dept HAVING COUNT(*) > 10;

SELECT dept, COUNT(*) FROM employees WHERE COUNT(*) > 10 GROUP BY dept;

SELECT dept, COUNT(*) FROM employees GROUP BY dept > 10;

An error, because no default was declared

A permanent new column added to the customers table

A temporary label for that column in this query's output

TRUNCATE TABLE typically resets the AUTO_INCREMENT counter and runs faster

TRUNCATE TABLE only removes half of the existing rows

DELETE FROM can never remove every row from a table

It simplifies access to a complex or frequently repeated query

It stores an independent physical copy of the table's data

MySQL Quiz