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 |
+-------+------+---------------------------+
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/show-errors/