软件简介:1 D6 y3 S5 H W/ `: {2 \" T
MySQL 5中,出现错误提示:: R& M& Y7 J) O& O
Field 'id' doesn't have a default value
2 {7 Q6 E& d6 `' P. |: e6 T解决方法一:
8 i+ n; [9 h- m: J) ^打开my.ini,查找3 `: `0 ]0 p. X. ?' `3 [
sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION& E7 H% g# \9 ^
修改为
0 R' u+ H. l$ M0 X. t" v. wsql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
2 I5 h1 v. ?# l6 ?0 L然后重启MYSQL
5 d9 S) C, H: u% r" q8 ^0 P& p
+ O: M3 j0 B. k, f
7 G3 A: O* G4 \' h7 v下载地址:
|