Jun 7, 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
sql-mode=NO_ENGINE_SUBSTITUTION 
and
sql-mode='NO_ENGINE_SUBSTITUTION'
will work.