mysql增加字段1067_MySQL INSERT,无需指定每个非默认字段(#1067 – ‘table’的默认值无效)...

默认情况下,其中一台服务器以严格模式运行,而另一台服务器则没有.

如果服务器以严格模式运行(或者在连接中设置它)并且您尝试将NULL值插入到定义为NOT NULL的列中,则会出现#1364错误.如果没有严格模式,您的NULL值将替换为空字符串或0.

例：

CREATE TABLE `test_tbl` (

`id` int(11) NOT NULL,

`someint` int(11) NOT NULL,

`sometext` varchar(255) NOT NULL,

`somedate` datetime NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

SET sql_mode = '';

INSERT INTO test_tbl(id) VALUES(1);

SELECT * FROM test_tbl;

+----+---------+----------+---------------------+

| id | someint | sometext | somedate |

+----+---------+----------+---------------------+

| 1 | 0 | | 0000-00-00 00:00:00 |

+----+---------+----------+---------------------+

SET sql_mode = 'STRICT_ALL_TABLES';

INSERT INTO test_tbl(id) VALUES(2);

#1364 - Field 'someint' doesn't have a default value