How to turn on/off MySQL strict mode in localhost (xampp)?
->STRICT_TRANS_TABLES is responsible for setting MySQL strict mode. ->To check whether strict mode is enabled or not run the below sql: SHOW VARIABLES LIKE ‘sql_mode’; If one of the value is STRICT_TRANS_TABLES, then strict mode is enabled, else not. In my case it gave +————–+——————————————+ |Variable_name |Value | +————–+——————————————+ |sql_mode |STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION| +————–+——————————————+ Hence strict mode … Read more