SHOW ERRORS

SHOW ERRORS 语句用于显示已执行语句中的错误。一旦先前的语句成功执行,就会清除错误缓冲区,这时 SHOW ERRORS 会返回一个空集。

当前的 sql_mode 很大程度决定了哪些语句会产生错误与警告。

语法图

ShowErrorsStmt

SHOW ERRORS - 图1

ShowLikeOrWhere

SHOW ERRORS - 图2

  1. ShowErrorsStmt ::=
  2. "SHOW" "ERRORS" ShowLikeOrWhere?
  3. ShowLikeOrWhere ::=
  4. "LIKE" SimpleExpr
  5. | "WHERE" Expression

示例

  1. select invalid;
  1. ERROR 1054 (42S22): Unknown column 'invalid' in 'field list'
  1. create invalid;
  1. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 14 near "invalid"
  1. SHOW ERRORS;
  1. +-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
  2. | Level | Code | Message |
  3. +-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
  4. | Error | 1054 | Unknown column 'invalid' in 'field list' |
  5. | Error | 1064 | You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 14 near "invalid" |
  6. +-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
  7. 2 rows in set (0.00 sec)
  1. CREATE invalid2;
  1. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 15 near "invalid2"
  1. SELECT 1;
  1. +------+
  2. | 1 |
  3. +------+
  4. | 1 |
  5. +------+
  6. 1 row in set (0.00 sec)
  1. SHOW ERRORS;
  1. Empty set (0.00 sec)

MySQL 兼容性

SHOW ERRORS 语句与 MySQL 完全兼容。如发现任何兼容性差异,请尝试 TiDB 支持资源

另请参阅