Skip to main content

Queries for MySQLs

MySQL SQL fundamentals are the statements that read and change data: SELECT with WHERE, ORDER BY and LIMIT, plus INSERT, UPDATE and DELETE. This unit is in the Getting Started stage and covers filtering with operators, pattern matching with LIKE, handling NULL correctly and understanding the order in which a query is evaluated.

Stage: Getting Started · Part of the MySQL roadmap · Last reviewed 19 November 2026

What to learn in Queries

Queries interview questions

Why does WHERE column = NULL return no rows?

NULL means unknown, and any comparison with it using = yields NULL, not true. To find missing values use IS NULL or IS NOT NULL. MySQL also offers the null-safe equals operator, written as <=>, for comparisons that treat two NULLs as equal.

What is the difference between DELETE and TRUNCATE?

DELETE removes rows that match a condition, can be rolled back inside a transaction and fires row triggers. TRUNCATE removes every row quickly by recreating the table, resets AUTO_INCREMENT and cannot take a WHERE clause. TRUNCATE is DDL and commits implicitly.

Where Queries fits in the MySQL roadmap

Queries belongs to the Getting Started stage (beginner level), which takes about 20 hours. Install and query.

Back to the full MySQL roadmap