Show Errors in MySQL

Posted by admin

May 6, 2008

SHOW ERRORS [LIMIT [offset,] row_count]
SHOW COUNT(*) ERRORS

This statement is similar to SHOW WARNINGS, except that instead of displaying errors, warnings,
and notes, it displays only errors. SHOW ERRORS is available as of MySQL 4.1.0.
The LIMIT clause has the same syntax as for the SELECT statement. See Section 6.1.7, “SELECT
Syntax.”

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;

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.