🚀  Our new eBook is out – “CI/CD for Monorepos.” Learn how to effectively build, test, and deploy code with monorepos. Download now →

MySQL Strict Mode And You

We’ve recently upgraded MySQL 5.5 to 5.6 in our platform. Along with many performance and stability improvements, the new version also has strict mode turned on by default, which means it has stricter syntax and data validation checking. This, of course, is a good thing from your data’s standpoint but it may also cause some unexpected errors in your builds.

To turn off MySQL’s strict mode, you’ll have to add the following command to your build commands in project settings.

mysql -u root -psemaphoredb -e "SET @@global.sql_mode= '';"

For more information about MySQL modes, you can check out the official documentation here.

Have a comment? Join the discussion on the forum