MySQL Tips And Tricks
If you encounter errors when importing or creating tables in MySQL with default date values as zero, then you might want to change your
Check your setting: show variables like 'sql_mode' ;
Set new settings without "NO_ZERO_IN_DATE,NO_ZERO_DATE":
set global sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
Last modified
2021-02-09