MySQL管理之道-笔记-MySQL5.7 sql_mode的改变
root@localhost:mysql3306.sock >set sql_mode=''; Query OK, 0 rows affected, 1 warning (0.02 sec)root@localhost:mysql3306.sock >insert into t1 values(1,'aa','aaa');
Query OK, 1 row affected, 1 warning (0.04 sec)
root@localhost:mysql3306.sock >show warnings;
+---------+------+----------------------------------------------------------+
| Level | Code | Message |
+---------+------+----------------------------------------------------------+
| Warning | 1366 | Incorrect integer value: 'aaa' for column 'age' at row 1 |
+---------+------+----------------------------------------------------------+
row in set (0.00 sec)
页:
[1]