Seeing Full Warnings That Just Happened After a Query

After you run a query on MySQL server you may get warning messages. To see the complete warnings you simply run the command show warnings. It’s important to run this immediately after the query in question otherwise the warnings are lost.

Command Show Latest Warnings
show warnings;
If you have warnings, you’ll see them like below
Query OK, 254 rows affected, 46 warnings (0.12 sec)
Records: 298  Duplicates: 44  Warnings: 46

Leave a Reply

Your email address will not be published. Required fields are marked *