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

Topic: MySQL出错 - Field 'Sline' doesn't have a default value

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

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

Copy to clipboard

Posted by: MG12
Posted on: 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