Singapore Flyer

Sunday, December 30, 2012

How to disable STRICT_MODE in mysql ?

Login to mysql server
# Check global settings for strict mode
mysql> select @@GLOBAL.sql_mode;
+--------------------------------------------------------------+
| @@GLOBAL.sql_mode                                            |
+--------------------------------------------------------------+
| STRICT_ALL_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------------------------+

# Remove settings
mysql> SET GLOBAL sql_mode="";
   
# Verify
mysql> select @@GLOBAL.sql_mode;
+-------------------+
| @@GLOBAL.sql_mode |
+-------------------+
|                   |
+-------------------+

No comments:

Post a Comment