Digital Marketing

How to get rid of STRICT SQL mode in MySQL

Put sql-mode="" in an option file. For example, on CentOS, 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.


Popular posts from this blog

MySQL Sandbox with the Sakila sample database