mysql在插入时显示警告而不是错误,并且没有为设置为非null的列赋值 – 字段没有默认值

我很确定在以前的版本MySQL中不允许这样生成和错误并且实际上没有插入行.这是配置问题吗？那是怎么回事？

mysql> CREATE TABLE `test` (
  `field1` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Query OK, 0 rows affected (0.07 sec)

mysql> INSERT INTO test VALUES ();
Query OK, 1 row affected, 1 warning (0.01 sec)

mysql> SHOW WARNINGS\G
*************************** 1. row ***************************
  Level: Warning
   Code: 1364
Message: Field 'field1' doesn't have a default value
1 row in set (0.00 sec)

mysql> SELECT * FROM test;
+--------+
| field1 |
+--------+
|      0 |
+--------+
1 row in set (0.00 sec)

这与sql_mode变量有关：

> @@ GLOBAL.sql_mode
> @@ SESSION.sql_mode

当您将其设置为“TRADITIONAL”时,它会开始出错：

mysql> SET @@SESSION.sql_mode='TRADITIONAL';
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO test VALUES ();
ERROR 1364 (HY000): Field 'field1' doesn't have a default value

Documentation about SQL modes