I'm trying to run the following script in MySQL Workbench:
UPDATE `people` SET `dateDied` = '0000-00-00';
And I get this error:
Error Code: 1292. Incorrect date value: '0000-00-00' for column 'dateDied' at row 1
Now I have already disabled strict mode in the my.ini
that MySQL Workbench is set to use
sql_mode = ""
I did a scan for any my.ini
in my drive where MySQL is installed and that is the only one I see that exists. I have a Laravel application running with strict mode off just fine but for whatever reason MySQL Workbench is giving me that error and I don't know why. It's almost like its ignoring that value. I have restarted MySQL and MySQL Workbench several times but cannot get that script to run successfully.
What am I missing?
Running MySQL Workbench as Administrator and running this query resolved it for me:
SET GLOBAL sql_mode = '';
For some reason updating the my.ini with the following did not take care of it.
sql_mode = ''