MySQL Exercises
Test your MySQL skills with exercises from all categories:
Exercises
Tip: Sign in to track your progress - it's free.
0/50 done
Intro3 exercises
RDBMS3 exercises
About SQL Statements3 exercises
SELECT4 exercises
WHERE3 exercises
AND OR NOT4 exercises
ORDER BY3 exercises
INSERT3 exercises
NULL values3 exercises
UPDATE3 exercises
DELETE3 exercises
LIMIT3 exercises
MIN MAX3 exercises
COUNT AVG SUM3 exercises
LIKE5 exercises
Wildcards3 exercises
IN3 exercises
BETWEEN3 exercises
Alias3 exercises
JOIN3 exercises
INNER JOIN3 exercises
LEFT JOIN3 exercises
RIGHT JOIN3 exercises
CROSS JOIN3 exercises
UNION3 exercises
GROUP BY3 exercises
HAVING3 exercises
EXISTS3 exercises
ANY, ALL5 exercises
INSERT INTO SELECT4 exercises
CASE3 exercises
IFNULL() and COALESCE()3 exercises
Comments5 exercises
Operators7 exercises
CREATE DATABASE5 exercises
DROP DATABASE5 exercises
CREATE TABLE4 exercises
DROP TABLE7 exercises
ALTER TABLE6 exercises
Constraints5 exercises
NOT NULL4 exercises
UNIQUE4 exercises
PRIMARY KEY4 exercises
FOREIGN KEY5 exercises
CHECK4 exercises
DEFAULT4 exercises
CREATE INDEX5 exercises
AUTO_INCREMENT4 exercises
Dates3 exercises
Views5 exercises
Log in to track your progress
If you haven't already, sign up to become a W3Schooler, and get points for every exercise you complete.
As a logged-in W3Schools user you will have access to many features like having your own web page, track your learning progress, receive personal guided paths, and more.
The Exercise
The exercises are a mix of "multiple choice" and "fill in the blanks" questions. There are between 3 and 9 questions in each category. The answer can be found in the corresponding tutorial chapter. If you're stuck, or answer wrong, you can try again or hit the "Show Answer" button to see the correct answer.