gistfile1.txt

mysql56> SELECT @@version;
+------------+
| @@version  |
+------------+
| 5.6.19-log |
+------------+
1 row in set (0.00 sec)

mysql56> SELECT @@sql_mode;
+------------+
| @@sql_mode |
+------------+
|            |
+------------+
1 row in set (0.00 sec)

mysql56> CREATE TABLE t1 (num int);
Query OK, 0 rows affected (0.04 sec)

mysql56> INSERT INTO t1 VALUES ('');
Query OK, 1 row affected, 1 warning (0.02 sec)

mysql56> SHOW WARNINGS;
+---------+------+-------------------------------------------------------+
| Level   | Code | Message                                               |
+---------+------+-------------------------------------------------------+
| Warning | 1366 | Incorrect integer value: '' for column 'num' at row 1 |
+---------+------+-------------------------------------------------------+
1 row in set (0.00 sec)

mysql56> SET SESSION sql_mode= STRICT_TRANS_TABLES;
Query OK, 0 rows affected (0.00 sec)

mysql56> INSERT INTO t1 VALUES ('');
ERROR 1366 (HY000): Incorrect integer value: '' for column 'num' at row 1

mysql56> SET SESSION sql_mode= '';
Query OK, 0 rows affected (0.00 sec)

mysql56> INSERT INTO t1 VALUES ('');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql56> SHOW WARNINGS;
+---------+------+-------------------------------------------------------+
| Level   | Code | Message                                               |
+---------+------+-------------------------------------------------------+
| Warning | 1366 | Incorrect integer value: '' for column 'num' at row 1 |
+---------+------+-------------------------------------------------------+
1 row in set (0.00 sec)