Mysql Incorrect integer value(1366)错误解决方法

[yehlu]

http://blog.csdn.net/lqc851011/article/details/5904598

/etc/my.cnf

代碼: 選擇全部

sql_mode = ALLOW_INVALID_DATES,IGNORE_SPACE,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

代碼: 選擇全部

SHOW VARIABLES LIKE 'sql_mode';

[yehlu]

http://stackoverflow.com/questions/1876 ... e-in-mysql


6
down vote
On Centos 6.5 i had to edit /usr/my.cnf and set (even though /etc/my.cnf existed and bindings were successfully set there

請關掉 /usr/my.cnf