How to check the last warning or Error in MySQL

Do you know you can check the last warning or last error thrown by MySQL. Sometimes it is useful to check the last warning or error thrown by MySQL.

Here we will see how we can check the last warning or error in MySQL.

Check last warning by MySQL

Last warning can be checked by using Show warnings statement.

Show warnings;

Check last error thrown by MySQL

Last error in MySQL can be seen by executing show errors statement

Show errors;

Scroll to Top