Recent days i am working with my live project when i face any problem in my web application, i have to download the whole database and then restoring it to localhost. But facing a lots of problem, like
ERROR 1292 (22007) at line 3236: Incorrect datetime value: ” for column ‘deleted_at’ at row 1
So what is the solution!!
SELECT @@GLOBAL.sql_mode global, @@SESSION.sql_mode session; SET sql_mode = ''; SET GLOBAL sql_mode = '';
Run this line, it will solve your problem.