how to fix strict mode in mysql code example
Example: strict mode in mysql
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