Java开发网 - Re:MySQL出错 - Field 'Sline' doesn't have a default value

Java开发网

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate » MySQL

打印话题 寄给朋友 订阅主题

作者	MySQL出错 - Field 'Sline' doesn't have a default value
MG12 发贴: 5 积分: 0	于 2006-04-26 15:29 新装了MySQL5.0 但运行以前在4.1的东西却提示“ Field 'Sline' doesn't have a default value ” 其中'Sline'是表中某列的列名请各位指点一下，谢谢！（缩略图，点击图片链接看原图）

作者

Re:MySQL出错 - Field 'Sline' doesn't have a default value [Re:MG12]

MG12

发贴: 5
积分: 0

于 2006-04-26 18:57

找到篇文章，算是解决了。

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.

来自：http://wordpress.org/support/topic/46047

已读帖子

新的帖子

被删除的帖子