Field 'id' doesn't have a default value昨晚做项目的时候遇到一个问题，在测试数据存储的时候老是报Field 'id' doesn't have a default value异常，从网上找了好久，根据各位大虾的说法也测试了好久好久，可就是没发现原因所在，鼓捣了两三个小时的时间，最后总算找到问题所在：原来是我的数据设计的时候，把主键的类型定义为int的，原本想是用自增的方式来的，可是由于自己的粗心，写sql语句的时候没有加上auto_increment,所以在数据存储的时候老是报Field 'id' doesn't have a default value，id根本就没有值啊！！
加上自己从网上找的其他人说的他们遇到这种时候的原因，在这里总结一下：
1、打开my.ini，查找
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
修改为
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
然后重启MYSQL
2、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.
3、看看你的数据库定义的时候是不是把主键生成方式设置为int的，但是没有设置为自增的！！或者数据定义的时候设置一个默认值就可以了。
本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/q283595518/archive/2009/04/25/4122053.aspx
分享到：
相关推荐
### 解决Field 'ssl_cipher' doesn't have a default value的错误 #### 背景介绍 在使用MySQL数据库的过程中，可能会遇到一个特定的错误：“Field 'ssl_cipher' doesn't have a default value”。这个错误通常发生...
在使用MySQL时，可能会遇到“Field '***' doesn't have a default value”的错误，这个问题通常发生在尝试插入数据到数据库表时，某个字段没有提供值，而该字段在表定义中被设定为非空（NOT NULL）且没有设置默认值...
- The field "Default Gateway" has been added to the NetLink's configuration property page - The string write from the OPC Server sometimes failed . This bug has been fixed - After driver uninstall...
如果你的数据库表中 `id` 字段的数据类型是字符串或其他非数字类型，那么就会出现“Field 'id' doesn't have a default value”的异常，因为数据库无法接受这种类型转换。 为了解决这个问题，我们需要告诉 MyBatis-...
.- Reduced the line sleep to 30 (tell me if this value doesn‘t work for you).27/4/981.7.0- Fixed a memory leak, thanks to Don Higgins.- Moved the string esErrorInFormatOfMsg to a property of SakPOP.-...
directive because it is not set or is mistyped, a default value will be used. ; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one ; of the INI constants (On, Off, True, ...
* TClientDataSet doesn‘t save data to file when FileName is set and there is no existing file on disk (Quality Central 2307). * Using the Delphi 7 version of midas.dll to open an XML file that was ...
The device must have a point-ing ap¬para¬tus or method (such as a stylus, or a finger touching a touch pad), called the cursor, that de¬fines the current position. The cursor must be able to ...
This uniqueifier is a 4-byte value added as an additional sort key to only the rows that have duplicates of their primary sort key. You can see this extra value if you use DBCC PAGE to look at the ...
Third, if ISPs decide to charge more money to highly profitable content providers (in countries where net neutrality doesn't apply), the content providers can avoid these extra payments. 16. The ...
link ▶Don't use an #include when a forward declaration would suffice. When you include a header file you introduce a dependency that will cause your code to be recompiled whenever the header file ...
is a region field. A buffer object is also allowed as the source operand. BZ 480 Fixed a problem where the Load ASL operator allowed the source operand to be an operation region of any type. It is ...
* [MNG-4941] - PluginDescriptorBuilder doesn't populate expression/default-value fields for mojo parameters * [MNG-4952] - [regression] RELEASE field of repository metadata is not updated upon ...
capability isn't supported by a chosen protocol, the JavaMail API doesn't magically add the capability on top of it. (As you'll soon see, this can be a problem when working with POP.) SMTP The ...
Have a special column to show Field Captions Can customize inplace editor and data of the cell like in DBGridEh. TDBLookupComboboxEh component Provides all functionality of TDBLookupCombobox and ...
Have a special column to show Field Captions Can customize inplace editor and data of the cell like in DBGridEh. TDBLookupComboboxEh component Provides all functionality of TDBLookupCombobox and ...
Have a special column to show Field Captions Can customize inplace editor and data of the cell like in DBGridEh. TDBLookupComboboxEh component Provides all functionality of TDBLookupCombobox and ...
with a scrollable list and can display and edit a field in a dataset or can works as non data-aware combo edit control. TDBNumberEditEh component represents a single-line number edit control that ...
Have a special column to show Field Captions Can customize inplace editor and data of the cell like in DBGridEh. TDBLookupComboboxEh component Provides all functionality of TDBLookupCombobox and ...