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.
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
Command Show Latest Warnings