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
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
andsql-mode='NO_ENGINE_SUBSTITUTION'
will work.
Comments
Post a Comment