MySQL quiz

Test your MySQL knowledge with a free interactive quiz — 50 questions with answers and explanations. No signup needed to play.

What does `AUTO_INCREMENT` do?

1. What does `AUTO_INCREMENT` do?
2. What does `INSERT INTO ... ON DUPLICATE KEY UPDATE` do?
3. Which clause sorts the result set?
4. Which SQL statement retrieves rows from a table?
5. What is a `FOREIGN KEY`?
6. What is a `PRIMARY KEY`?
7. What does a `LEFT JOIN` return?
8. What clause limits the number of rows returned?
9. What does `DISTINCT` do?
10. How is `NULL` handled in equality comparisons?
11. What does `JOIN` do in SQL?
12. What does `mysqldump` produce by default?

More quizzes