Search This Blog

Sunday, November 18, 2018

How to get rid of STRICT SQL mode in MySQL

Put sql-mode="" in an option file. For example, on CentOS 6, there is /usr/my.cnf you need to modify.

One thing need to watch out is that you need to search both sql-mode and sql_mode, in case there is existing setting. Although in the MySQL document it only mentions sql-mode for option file.

And both
will work.