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.
To learn about handling error …[Read more...]