Show warnings : Show « Command MySQL « SQL / MySQL

1. SQL / MySQL
2. Command MySQL
3. Show

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>

   
    
    
    
    
    
    
    
  

Related examples in the same category