{"id":8417,"date":"2019-09-04T19:49:51","date_gmt":"2019-09-05T02:49:51","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=8417"},"modified":"2023-11-30T18:19:51","modified_gmt":"2023-12-01T01:19:51","slug":"mysql-show-errors","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-stored-procedure\/mysql-show-errors\/","title":{"rendered":"MySQL SHOW ERRORS"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the MySQL SHOW ERRORS<\/code> statement to display error information generated by a query.<\/p>\n\n\n\n

Introduction to MySQL SHOW ERRORS statement<\/h2>\n\n\n\n

The SHOW ERRORS<\/code> statement is used to display error information about the most recent execution of a statement or a stored procedure.<\/p>\n\n\n\n

The SHOW ERRORS<\/code> statement works like the SHOW WARNINGS<\/a><\/code> statement but it shows only errors, not warnings, and notes.<\/p>\n\n\n\n

Here’s the basic syntax of the SHOW ERRORS<\/code> statement:<\/p>\n\n\n

SHOW<\/span> ERRORS<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
To limit the number of errors, you use the SHOW ERRORS LIMIT<\/code> statement:<\/p>\n\n\n
SHOW<\/span> ERRORS<\/span> [LIMIT<\/span> [offset<\/span>,] row_count<\/span>];<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
To get the total number of errors, you use the following form of the SHOW ERRORS<\/code> statement:<\/p>\n\n\n
SHOW<\/span> COUNT<\/span>(*) ERRORS<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Alternatively, you can select it from the system variable @@error_count<\/code>:<\/p>\n\n\n
SELECT<\/span> @@error_count;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
MySQL SHOW ERRORS statement example<\/h2>\n\n\n\n
We’ll use the products<\/code> table from the sample database<\/a> for the demonstration:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
The following statement attempts to retrieve the values from the id column of the products<\/code> table:<\/p>\n\n\n
SELECT<\/span> id<\/span> FROM<\/span> products;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
MySQL issues an error because the products<\/code> table does not have the id<\/code> column:<\/p>\n\n\n
ERROR 1054<\/span> (42<\/span>S22): Unknown column 'id'<\/span> in<\/span> 'field list'<\/span><\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
In the message:<\/p>\n\n\n\n
    \n
  • ERROR<\/code> indicates that the message is an error message.<\/li>\n\n\n\n
  • 1054<\/code> is an integer that represents the MySQL error code.<\/li>\n\n\n\n
  • 42S22<\/code> is a  five-character alphanumeric code that represents the condition of the most recently executed SQL statement.<\/li>\n\n\n\n
  • \"Unknown column 'id' in 'field list'\"<\/code> represents the detailed error message.<\/li>\n<\/ul>\n\n\n\n
    To show the errors, you use the SHOW ERRORS<\/code> statement:<\/p>\n\n\n
    SHOW<\/span> ERRORS<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    +-------+------+-------------------------------------+\r\n| Level | Code | Message                             |\r\n+-------+------+-------------------------------------+\r\n| Error<\/span> | 1054<\/span> | Unknown column 'id'<\/span> in<\/span> 'field list'<\/span> |\r\n+-------+------+-------------------------------------+\r\n1<\/span> row in<\/span> set<\/span> (0.00 sec)<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
    To get the total number of errors, you use the error_count<\/code> variable:<\/p>\n\n\n
    SELECT<\/span> @@error_count;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    +-----------------------+\r\n| @@session.error_count |\r\n+-----------------------+\r\n|                     0<\/span> |\r\n+-----------------------+\r\n1<\/span> row in<\/span> set<\/span> (0.00 sec)<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
    Summary<\/h2>\n\n\n\n
      \n
    • Use the MySQL SHOW ERRORS<\/code> statement to display errors of the most recently executed statement.<\/li>\n<\/ul>\n
      \n\t
      \n\t\t
      Was this tutorial helpful? <\/div>\n\t\t
      \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
      \n\t\t
      \n\t\t\t
      <\/div>\n\t\t\t\n\t\t\t
The LIMIT<\/a><\/code> clause has the same meaning as it does in the SELECT<\/a><\/code> statement.<\/p>\n\n\n\n