sqlANYselectall
sql
SELECT * FROM users;Convenient for quick exploration, but explicit column lists are usually better in production queries.
MySQL SELECT, INSERT, UPDATE, and DELETE Cheatsheet
practical MySQL CRUD queries including filtering, sorting, pagination basics, inserts, updates, deletes, truncation, and upsert patterns.
Export
Copy the compact sheet, download it, or print it.
Download
`D` dense toggle · `C` copy all
basic selects
The most common retrieval patterns developers use every day.
sqlANYselectcolumns
sql
SELECT id, email, full_name FROM users;Reducing selected columns helps readability and can reduce network overhead.
sqlANYwherefilter
sql
SELECT id, email FROM users WHERE is_active = 1;`WHERE` narrows the result set before ordering and limiting.
sqlANYorder-bylimit
sql
SELECT id, email, created_at FROM users ORDER BY created_at DESC LIMIT 20;A common pattern for feeds, admin lists, and dashboards.
sqlANYdistinctstatus
sql
SELECT DISTINCT status FROM orders ORDER BY status;Useful for reporting, filters, and data exploration.
sqlANYlikesearchwildcard
sql
SELECT id, email FROM users WHERE email LIKE '%@example.com';For large datasets, full-text or prefix-specific search patterns may be more efficient.
sqlANYbetweendatesreporting
sql
SELECT id, created_at FROM orders WHERE created_at BETWEEN '2026-01-01' AND '2026-01-31 23:59:59';Use explicit endpoints to avoid off-by-one issues in reporting.
insert, update, and delete
Modify data safely with common write patterns.
sqlANYinsertcreate
sql
INSERT INTO users (email, full_name) VALUES ('ava@example.com', 'Ava Stone');Always listing target columns makes inserts safer during schema changes.
sqlANYinsertbatch
sql
INSERT INTO users (email, full_name) VALUES
('liam@example.com', 'Liam Cole'),
('mia@example.com', 'Mia Shaw');Batch inserts reduce round trips and are often much faster than many single-row statements.
sqlANYupdatewhere
sql
UPDATE users SET is_active = 0 WHERE email LIKE '%@old-domain.com';Always include a restrictive `WHERE` clause unless you intentionally want to update every row.
sqlANYdeletecleanup
sql
DELETE FROM sessions WHERE expires_at < NOW();A classic cleanup task for expired sessions or temporary data.
sqlANYtruncatestaging
sql
TRUNCATE TABLE staging_events;Faster than `DELETE` for clearing a whole table, but behaves differently with transactions and foreign keys.
sqlANYupsertduplicate-key
sql
INSERT INTO users (email, full_name)
VALUES ('ava@example.com', 'Ava Stone')
ON DUPLICATE KEY UPDATE full_name = VALUES(full_name);A classic MySQL upsert pattern for unique-keyed rows.
sqlANYreplaceupsert
sql
REPLACE INTO feature_flags (flag_key, flag_value) VALUES ('beta_ui', 'on');`REPLACE` can have surprising semantics because it may delete the old row and insert a new one.
More in MySQL
MySQL Procedures, Triggers, and Events Cheatsheet
stored procedures, stored functions, delimiters, call, triggers, and scheduled events in MySQL.
MySQL Functions, JSON, and Date Cheatsheet
now, date_add, date_sub, date_format, timestampdiff, json_extract, json_set, json_object, concat, coalesce, and case in MySQL.
MySQL Backup, Restore, Import, and Export Cheatsheet
mysqldump, mysql restore, load data infile, select into outfile, mysqlimport, and MySQL Shell dump/load workflows.
MySQL Users, Grants, and Privileges Cheatsheet
create users, alter passwords, grant privileges, show grants, revoke access, and manage MySQL accounts safely.
MySQL Transactions and Locking Cheatsheet
start transaction, commit, rollback, savepoints, select for update, isolation levels, and InnoDB lock troubleshooting.
MySQL Indexes, EXPLAIN, and Performance Cheatsheet
index design, show index, explain, explain analyze, analyze table, and practical performance tuning workflows in MySQL.