SHOW VARIABLES LIKE 'sql_mode'; -- enabled if STRICT_TRANS_TABLES is present SET GLOBAL sql_mode=''; -- disables strict mode SET GLOBAL sql_mode='STRICT_TRANS_TABLES'; -- enables strict mode