set sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' ;
set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';
show variables like 'sql_mode%'\G
FLUSH PRIVILEGES;
set sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' ;
set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';
show variables like 'sql_mode%'\G
FLUSH PRIVILEGES;
转载于:https://my.oschina.net/Kxvz/blog/2993049