<![CDATA[观夏Note]]> //gm.angeldm.com/index.php zh-cn //gm.angeldm.com/post// <![CDATA[MySQL出错 - Field ‘*’ doesn’t have a default value]]> 果面 <admin@yourname.com> Mon, 04 Aug 2008 09:02:54 +0000 //gm.angeldm.com/post//
error_reporting(7);

仔细看了php页面,只有简单的一个sql执行比较有可能,于是输出了sql语句一看,语法方面都很正常

拿到phpmyadmin执行一看,才看到了经常看到的错误:

引用
   MySQL 返回：
   #1364 - Field 'guest' doesn't have a default value

好像装了5.0之后的版本就会了


查了下,发现网上有这么一句话:

引用
    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.


就是这里啦 呵呵

点击在新窗口中浏览此图片

刷新下 问题解决 ]]> //gm.angeldm.com/read.php?&guid=0#topreply <![CDATA[[评论] MySQL出错 - Field ‘*’ doesn’t have a default value]]> <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 //gm.angeldm.com/read.php?&guid=0#topreply