Field 'buildTime' doesn't have a default value是怎么回事

Field 'buildTime' doesn't have a default value是怎么回事
Field 'buildTime' doesn't have a default value是怎么回事

Field 'buildTime' doesn't have a default value是怎么回事
Field 'id' doesn't have a default value问题解决方法
MySQL 5中,出现错误提示：
Field 'id' doesn't have a default value

解决方法一：

打开my.ini,查找
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

修改为

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

然后重启MYSQL

解决方法二：
MySQL 5 uses a strict mode which needs to be disabled.
In Windows, Goto Start-->Programs-->MySQL->MySQL Instance Config Wizard. Follow through the Reconfigure Instance option-->Detailed Configuration-->Continue Next a few screens. At the bottom under Enable TCP/IP option there is 'Enable Strict Mode'. Deslect this option (no tick). Save changes and MySQL will restart

楼上的太详细，不说了！

你的数据库里面 buildTime 字段属性 有没有设置了自动增长？
不知道是不是类似的问题。我的改成自动增长，错误就没了。