The State of the Dolphin...

Monday Aug 04, 2014

To ensure that your MySQL Database works as efficiently as possible, it is important to know how to handle error messages and warnings.

Error messages have three components:

A MySQL-specific error code, such as 1146

A SQLSTATE error code. These codes are defined by standard SQL and the ODBC standard.

A text message that describes the problem

MySQL Server generates a warning when it is not fully able to comply with a request or when an action has possibly unintended side effects. You can display these warnings with the SHOW WARNINGS statement.