SHOW ERRORS [LIMIT [offset
,]row_count
] SHOW COUNT(*) ERRORS
SHOW ERRORS
is a diagnostic statement that is similar to 是一个类似于SHOW WARNINGS
, except that it displays information only for errors, rather than for errors, warnings, and notes.SHOW WARNINGS
的诊断语句,只是它只显示错误的信息,而不是错误、警告和注释的信息。
The LIMIT
clause has the same syntax as for the SELECT
statement. See Section 13.2.10, “SELECT Statement”.LIMIT
子句的语法与SELECT
语句的语法相同。参见第13.2.10节,“SELECT语句”。
The SHOW COUNT(*) ERRORS
statement displays the number of errors. SHOW COUNT(*) ERRORS
语句显示错误数。You can also retrieve this number from the 您也可以从error_count
variable:error_count
变量中检索此数字:
SHOW COUNT(*) ERRORS; SELECT @@error_count;
SHOW ERRORS
and error_count
apply only to errors, not warnings or notes. SHOW ERRORS
和error_count
仅适用于错误,而不适用于警告或注释。In other respects, they are similar to 在其他方面,它们类似于SHOW WARNINGS
and warning_count
. SHOW WARNINGS
和warning_count
。In particular, 特别是,SHOW ERRORS
cannot display information for more than max_error_count
messages, and error_count
can exceed the value of max_error_count
if the number of errors exceeds max_error_count
.SHOW ERRORS
不能显示超过max_error_count
消息的信息,如果错误数超过max_eerror_count
,则error_count
可能超过max_error_count
的值。
For more information, see Section 13.7.7.42, “SHOW WARNINGS Statement”.有关更多信息,请参阅第13.7.7.42节,“SHOW WARNINGS语句”。