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
