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 |
+-------------------+
| |
+-------------------+
# 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