mysql

MySQL Tips And Tricks

Submitted by Greg Nowak on 2021-02-09

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';