MySQL 5.0 Certification Study Guide

21.3. The SHOW ERRORS Statement

The SHOW ERRORS statement is similar to SHOW WARNINGS, but displays only messages for error conditions. As such, it shows only messages having a higher severity and tends to produce less output than SHOW WARNINGS.

SHOW ERRORS, like SHOW WARNINGS, supports a LIMIT clause to restrict the number of rows to return. It also can be used as SHOW COUNT(*) ERRORS to obtain a count of the error messages.