Field 'id' doesn't have a default value问题解决方法
Posted on 2011-02-26 14:16 黔人阿诺 阅读(485) 评论(0) 编辑 收藏 举报
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
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