26 Mar 2020 · Semaphore News

    MySQL Strict Mode And You

    1 min read
    Contents

    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.

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    Avatar
    Writen by: