-- 设置全局的sql_mode
SET GLOBAL sql_mode = '';
-- 设置session级别的的sql_mode
SET sql_mode = '';
-- 查询sql_mode,本地优先级最高
select @@sql_mode;
-- 查询全局的SQL_MODE变量值
select * from information_schema.SESSION_VARIABLES where VARIABLE_NAME like 'SQL_MODE';
-- 查询session级别的SQL_MODE变量值
select * from information_schema.GLOBAL_VARIABLES where VARIABLE_NAME like 'SQL_MODE';
-- 如果以上提示The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56'
-- 则执行以下
show variables like '%show_compatibility_56%';
set global show_compatibility_56=on;
show variables like '%show_compatibility_56%';
-- 无论设置全局还是session的变量sql_mode重启mysql后都会失效,
-- 要永久保存需要找到mysql的配置文件,添加一行sql_mode ="",我的目录是D:\wamp64\bin\mysql\mysql5.7.14\my.ini