Friday, August 12, 2016

MySQL / MariaDB - Show warning details

mysql> flush privileges;                                                 
Query OK, 0 rows affected, 5 warnings (0.08 sec)                         
                                                                         
mysql> \w;                                                               
Show warnings disabled.                                                  
ERROR:                                                                   
No query specified                                                       
                                                                         
mysql> show warnings;                                                    
+---------+------+-------------------------------------+                 
| Level   | Code | Message                             |                 
+---------+------+-------------------------------------+                 
| Warning | 1292 | Truncated incorrect time value: 'N' |                 
| Warning | 1292 | Truncated incorrect time value: 'N' |                 
| Warning | 1292 | Truncated incorrect time value: 'N' |                 
| Warning | 1292 | Truncated incorrect time value: 'N' |                 
| Warning | 1292 | Truncated incorrect time value: 'N' |                 
+---------+------+-------------------------------------+                 
5 rows in set (0.00 sec)

No comments:

Post a Comment