MySQL Tutorial/MySQL Utilities/SHOW WARNINGS

SHOW WARNINGS;

mysql>
mysql> SELECT ASIN("foo");
+-------------+
| ASIN("foo") |
+-------------+
|           0 |
+-------------+
1 row in set, 1 warning (0.00 sec)
mysql>
mysql> SHOW WARNINGS;
+---------+------+-----------------------------------------+
| Level   | Code | Message                                 |
+---------+------+-----------------------------------------+
| Warning | 1292 | Truncated incorrect DOUBLE value: "foo" |
+---------+------+-----------------------------------------+
1 row in set (0.00 sec)
mysql>