SHOW ERRORS
You are viewing an old version of this article. View
the current version here.
Syntax
SHOW ERRORS [LIMIT [offset,] row_count] SHOW ERRORS [LIMIT row_count OFFSET offset] SHOW COUNT(*) ERRORS
Description
This statement is similar to
SHOW WARNINGS
, except that instead of
displaying errors, warnings, and notes, it displays only errors.
The LIMIT
clause has the same syntax as for the
SELECT
statement.
The SHOW COUNT(*) ERRORS
statement displays the number of
errors. You can also retrieve this number from the error_count
variable.
SHOW COUNT(*) ERRORS; SELECT @@error_count;
The value of error_count
might be greater than the number of messages displayed by SHOW WARNINGS
if the max_error_count
system variable is set so low that not all messages are stored.
For a list of MariaDB error codes, see MariaDB Error Codes.
Examples
SELECT f(); ERROR 1305 (42000): FUNCTION f does not exist SHOW COUNT(*) ERRORS; +-----------------------+ | @@session.error_count | +-----------------------+ | 1 | +-----------------------+ SHOW ERRORS; +-------+------+---------------------------+ | Level | Code | Message | +-------+------+---------------------------+ | Error | 1305 | FUNCTION f does not exist | +-------+------+---------------------------+
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.