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