• Comment 

A brief description of the storage engine. 

• Transactions 

Whether the storage engine supports transactions. 

• XA 

Whether the storage engine supports XA transactions. 

• Savepoints 

Whether the storage engine supports savepoints. 

Storage engine information is also available from the INFORMATION_SCHEMA ENGINES  table. See Section 26.3.13, “The INFORMATION_SCHEMA ENGINES Table” . 

## 13.7.7.17 SHOW ERRORS Statement 

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. 

The LIMIT  clause has the same syntax as for the SELECT  statement. See Section 13.2.10, “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; 

SHOW ERRORS  and error_count  apply only to errors, not warnings or notes. In other respects, they are similar to SHOW WARNINGS  and 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 . 

For more information, see Section 13.7.7.42, “SHOW WARNINGS Statement” . 

## 13.7.7.18 SHOW EVENTS Statement 

SHOW EVENTS [{FROM | IN} schema_name ] [LIKE ’ pattern ’ | WHERE expr ] 

This statement displays information about Event Manager events, which are discussed in Section 25.4, “Using the Event Scheduler” . It requires the EVENT  privilege for the database from which the events are to be shown. 

In its simplest form, SHOW EVENTS  lists all of the events in the current schema: 

mysql> SELECT CURRENT_USER(), SCHEMA(); +----------------+----------+ | CURRENT_USER() | SCHEMA() | +----------------+----------+ 

