views:

28

answers:

0

I'd like to store warnings caused by some SQL statements in the database. E.g. after

mysql> select 1/0;
+------+
| 1/0  |
+------+
| NULL |
+------+
1 row in set, 1 warning (0.00 sec)

mysql> show warnings;
+-------+------+---------------+
| Level | Code | Message       |
+-------+------+---------------+
| Error | 1365 | Division by 0 |
+-------+------+---------------+
1 row in set (0.00 sec)

I'd like to save what SHOW WARNINGS says to some persistent table, to be able to analyze it in future.

Let's assume I know when there is something to log - I can check if @@warning_count > 0.