SQL MySQL Specific

MySQL-specific features — AUTO_INCREMENT, ENGINE, SHOW TABLES, LIMIT. This category documents 56 SQL mysql specific entries, and each page gives you the full syntax, the parameter list, the return value, and a runnable example tested against MySQL, PostgreSQL, SQL Server, and SQLite. The entries are: AUTO_INCREMENT, ENGINE, LAST_INSERT_ID(), ON DUPLICATE KEY UPDATE, LOAD DATA INFILE, LOCK TABLES / UNLOCK TABLES, FIND_IN_SET(), CHARACTER SET / COLLATION, SELECT ... FOR UPDATE (MySQL), SHOW WARNINGS, SHOW STATUS, REGEXP / RLIKE, GET_FORMAT(), UUID_SHORT(), ANY_VALUE(), MYSQL TIME FUNCTIONS, AES_ENCRYPT / AES_DECRYPT, HEX() / UNHEX(), JSON Data Type (MySQL), MySQL Generated Columns, MySQL DELIMITER Command, MySQL EVENT Scheduler, ANALYZE (MySQL), MySQL全文检索 MATCH AGAINST, WEIGHT_STRING(), PERFORMANCE_SCHEMA (MySQL), SQL_MODE (MySQL), IF / IFNULL / NULLIF, SHOW TABLE STATUS, FORCE INDEX / USE INDEX, BENCHMARK(), HANDLER Statement, SHOW TABLE (MySQL/MariaDB), MySQL EXPLAIN FORMAT=JSON, MySQL UNION Optimization, MySQL CTE (WITH clause), MySQL ON DUPLICATE KEY with VALUES(), MySQL Window Functions (8.0+), MySQL ROW_FORMAT, MySQL SHOW TABLE STATUS, and more. Not sure where to start? AUTO_INCREMENT and ENGINE are the most commonly used entries in this category. You can also search across every category from the search page, browse the complete A–Z index, or try any of these statements live in the SQL playground.