MySQL Exercises
Exercises
Test your MySQL skills with exercises from all categories:
Intro
RDBMS
About SQL Statements
SELECT
WHERE
AND OR NOT
ORDER BY
INSERT
NULL values
UPDATE
DELETE
LIMIT
MIN MAX
COUNT AVG SUM
LIKE
Wildcards
IN
BETWEEN
Alias
JOIN
INNER JOIN
LEFT JOIN
RIGHT JOIN
CROSS JOIN
UNION
GROUP BY
HAVING
EXISTS
ANY, ALL
INSERT INTO SELECT
CASE
IFNULL() and COALESCE()
Comments
Operators
CREATE DATABASE
DROP DATABASE
CREATE TABLE
DROP TABLE
ALTER TABLE
Constraints
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT
CREATE INDEX
AUTO_INCREMENT
Dates
Views
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 on 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 catergory. 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.
