SHOW Statements A brief description of the storage engine. Whether the storage engine supports transactions. Whether the storage engine supports XA transactions. 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” . SHOW EVENTS [{FROM | IN}  schema_name ] [LIKE ’ pattern ’ | WHERE  expr ] 13.7.7.18 SHOW EVENTS Statement 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: 2929 mysql>  SELECT CURRENT_USER(), SCHEMA(); +----------------+----------+ | CURRENT_USER() | SCHEMA() | +----------------+----------+ • Comment • Transactions • XA • Savepoints