软件简介:% n1 b% J# ^5 F; U6 I' |
MySQL 5中,出现错误提示:
1 y/ L+ o- z5 x W7 k1 oField 'id' doesn't have a default value8 w5 |+ @7 p5 r) o: Z
解决方法一:
5 I K: A! ]0 X; {打开my.ini,查找
$ @% C% z2 k( c+ |$ psql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
0 P- t/ k/ P8 \. h0 H! G修改为
* ^0 @( _0 I j" E7 rsql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
% x( X; K2 D; I6 X% m9 y然后重启MYSQL
) a- R4 u- [3 i
% R3 F- v% s, N X
R: A% K H. }7 q3 F下载地址:
|