SQL_MODE (MySQL)

SQL_MODE (MySQL) is a SQL statement in the MySQL Specific category. MySQL: SQL_MODE controls SQL syntax compatibility and validation strictness. The syntax is SET SESSION sql_mode = 'STRICT_ALL_TABLES,ONLY_FULL_GROUP_BY';. It returns sQL mode set. A typical example: SELECT @@sql_mode; -- Default: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,... -- Common modes: SET SESSION sql_mode = 'STRICT_ALL_TABLES'; -- Enables strict mode for all storage engines SET SESSION sql_mode = 'ONLY_FULL_GROUP_BY'; -- Rejects SELECT columns not in GROUP BY SET SESSION sql_mode = 'ALLOW_INVALID_DATES'; -- Accepts dates like '2026-02-30' SET SESSION sql_mode = ''; -- Disables all modes (least restrictive) A close relative is AUTO_INCREMENT, which mySQL auto-generates sequential integer values for this column. Commonly used with PRIMARY KEY. A close relative is ENGINE, which specifies the MySQL storage engine. InnoDB (default) supports transactions and foreign keys. MyISAM is faster for read-heavy. A close relative is LAST_INSERT_ID(), which returns the AUTO_INCREMENT value generated by the most recent INSERT in the current connection.