SHOW WARNINGS

    1. Query OK, 0 rows affected (0.11 sec)
    1. INSERT INTO t1 VALUES (0);
    1. Query OK, 1 row affected (0.02 sec)
    1. SELECT 1/a FROM t1;
    1. +------+
    2. | 1/a  |
    3. +------+
    4. | NULL |
    5. +------+
    6. 1 row in set, 1 warning (0.00 sec)
    1. +---------+------+---------------+
    2. +---------+------+---------------+
    4. +---------+------+---------------+
    5. 1 row in set (0.00 sec)
    1. INSERT INTO t1 VALUES (-1);
    1. ERROR 1264 (22003): Out of range value for column 'a' at row 1
    1. SELECT * FROM t1;
    1. +------+
    2. | a    |
    3. +------+
    4. |    0 |
    5. +------+
    6. 1 row in set (0.00 sec)
    1. Query OK, 0 rows affected (0.00 sec)
    1. INSERT INTO t1 VALUES (-1);
      1. +---------+------+---------------------------+
      2. | Level   | Code | Message                   |
      3. +---------+------+---------------------------+
      4. | Warning | 1690 | constant -1 overflows int |
      5. +---------+------+---------------------------+
      6. 1 row in set (0.00 sec)
      1. +------+
      2. | a    |
      3. +------+
      4. |    0 |
      5. |    0 |
      6. +------+
      7. 2 rows in set (0.00 sec)