Show MySQL warnings after query
Snippet
Posted by kitt at 14:35 on 12 October 2009
When a query has run, a number of warnings may have occurred that didn't stop the query from running, but may be of concern. Use "SHOW WARNINGS [LIMIT n]" to display the warnings and see what might have gone wrong in the query.
mysql> SELECT name, addr1, addr2, city, state, FROM_UNIXTIME(created_on) AS created FROM `orders` WHERE ...; Empty set, 20180 warnings (0.02 sec) mysql> show warnings limit 10; +---------+------+---------------------------------------------------------+ | Level | Code | Message | +---------+------+---------------------------------------------------------+ | Warning | 1292 | Truncated incorrect DOUBLE value: '2009-08-21 00:01:01' | | Warning | 1292 | Truncated incorrect DOUBLE value: '2009-08-26 00:01:01' | | Warning | 1292 | Truncated incorrect DOUBLE value: '2009-08-21 00:01:01' | | Warning | 1292 | Truncated incorrect DOUBLE value: '2009-08-26 00:01:01' |
Add new comment