Cacher is the code snippet organizer for pro developers

https://stackoverflow.com/questions/40881773/how-to-turn-on-off-mysql-strict-mode-in-localhost-xampp

to see if strict mode is enabled:
SHOW VARIABLES LIKE 'sql_mode';

look for "STRICT_TRANS_TABLES"

to disable strict mode:
set global sql_mode='';


to re-enable strict mode
set global sql_mode='STRICT_TRANS_TABLES';