Mysql的SQL模式
mysql> set @@sql_mode='';Query OK, 0 rows affected (0.00 sec)
mysql> select @@sql_mode;
+------------+
| @@sql_mode |
+------------+
| |
+------------+
1 row in set (0.00 sec)
mysql> insert into tbl_kenyon values(99,'123456');
Query OK, 1 row affected (0.00 sec)
mysql> insert into tbl_kenyon values(1,'1234567');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> insert into tbl_kenyon values('','123456');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> show warnings;
+---------+------+------------------------------------------------------+
| Level | Code | Message |
+---------+------+------------------------------------------------------+
| Warning | 1366 | Incorrect integer value: '' for column 'id' at row 1 |
+---------+------+------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select * from tbl_kenyon;
+------+--------+
| id | vname|
+------+--------+
| 1 | 123456 |
| NULL | 123456 |
| 99 | 123456 |
| 1 | 123456 |
| 0 | 123456 |
+------+--------+
5 rows in set (0.00 sec)
页:
[1]