Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Show warnings

mysql> mysql> SELECT '2004-13-12' + INTERVAL 1 DAY; +-------------------------------+ | '2004-13-12' + INTERVAL 1 DAY | +-------------------------------+ | NULL                          | +-------------------------------+ 1 row in set, 1 warning (0.00 sec) mysql> mysql> SHOW WARNINGS; +---------+------+----------------------------------------+ | Level   | Code | Message                                | +---------+------+----------------------------------------+ | Warning | 1292 | Incorrect datetime value: '2004-13-12' | +---------+------+----------------------------------------+ 1 row in set (0.00 sec) mysql>