code
ref
Cheat Sheets
Quick Reference
JSON Formatter
Learn
Tools
Browser Support
Search…
Ctrl K
Cheat Sheets
/
Databases
/
MySQL
MySQL
MySQL 8.4 statements, functions, data types and command-line tools.
Official reference ↗
Data Definition
CREATE DATABASE
CREATE TABLE
ALTER TABLE
DROP TABLE
TRUNCATE TABLE
RENAME TABLE
CREATE INDEX
DROP INDEX
CREATE VIEW
CREATE PROCEDURE
CREATE FUNCTION
CREATE TRIGGER
CREATE EVENT
Data Manipulation
Statements
SELECT
INSERT
UPDATE
DELETE
REPLACE
CALL
LOAD DATA
Clauses
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT
JOIN
UNION
WITH (CTE)
Subqueries
ON DUPLICATE KEY UPDATE
LIKE
Transactions
START TRANSACTION
COMMIT
ROLLBACK
SAVEPOINT
LOCK TABLES
SET TRANSACTION
SELECT ... FOR UPDATE
Administration
Users
CREATE USER
ALTER USER
DROP USER
GRANT
REVOKE
SHOW GRANTS
Inspect
SHOW DATABASES
SHOW TABLES
SHOW COLUMNS
SHOW CREATE TABLE
SHOW INDEX
SHOW PROCESSLIST
SHOW VARIABLES
DESCRIBE
EXPLAIN
USE
SET
String Functions
CONCAT()
CONCAT_WS()
LENGTH()
CHAR_LENGTH()
LOWER()
UPPER()
SUBSTRING()
LEFT()
RIGHT()
TRIM()
LTRIM()
RTRIM()
REPLACE()
INSTR()
LOCATE()
LPAD()
RPAD()
REVERSE()
REPEAT()
FORMAT()
Regex
REGEXP_LIKE()
REGEXP_REPLACE()
REGEXP_SUBSTR()
REGEXP_INSTR()
Numeric Functions
ABS()
CEIL()
FLOOR()
ROUND()
TRUNCATE()
MOD()
POW()
SQRT()
RAND()
SIGN()
Date & Time Functions
NOW()
CURDATE()
CURTIME()
DATE()
DATE_ADD()
DATE_SUB()
DATEDIFF()
DATE_FORMAT()
STR_TO_DATE()
YEAR()
MONTH()
DAY()
DAYOFWEEK()
LAST_DAY()
TIMESTAMPDIFF()
UNIX_TIMESTAMP()
FROM_UNIXTIME()
CONVERT_TZ()
Aggregate & Window
Aggregate
COUNT()
SUM()
AVG()
MIN()
MAX()
GROUP_CONCAT()
JSON_ARRAYAGG()
JSON_OBJECTAGG()
Window
ROW_NUMBER()
RANK()
DENSE_RANK()
LAG()
LEAD()
FIRST_VALUE()
LAST_VALUE()
NTILE()
Flow Control
CASE
IF()
IFNULL()
NULLIF()
COALESCE()
GREATEST()
LEAST()
JSON
JSON_OBJECT()
JSON_ARRAY()
JSON_EXTRACT()
->>
JSON_CONTAINS()
JSON_SET()
JSON_REMOVE()
JSON_TABLE()
Data Types
INT / BIGINT
DECIMAL
FLOAT / DOUBLE
BOOLEAN
CHAR / VARCHAR
TEXT / BLOB
ENUM
SET
DATE / DATETIME / TIMESTAMP
TIME
JSON
Command-Line Tools
mysql
mysqldump
mysqladmin
mysqlimport
mysqlcheck
mysqlshow
mysqlbinlog