软件简介:
6 Y" _5 @% b8 s2 EMySQL 5中,出现错误提示:
* A( v0 p4 X$ a9 iField 'id' doesn't have a default value' U# Q- B, \; L2 ]
解决方法一:& m9 m, m a& h
打开my.ini,查找
; [* D1 a$ ]8 n5 e/ isql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION( M: T7 ^ [( f8 \
修改为9 ~5 h3 q1 S+ r- d
sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
, a& ] E0 X' w" i3 e% E: R3 z然后重启MYSQL/ c5 E' j0 m" w
3 B; y. \+ ~7 x1 F( x
) I5 e& v# m4 R( f下载地址:
|