📣

TiDB Cloud Serverless 现已更名为
Starter
!此页面由 AI 自动翻译,英文原文请见
此处。

SHOW ERRORS

该语句显示之前执行的语句中的错误。当语句成功执行后,错误缓冲区会被清空。在这种情况下,SHOW ERRORS 将返回一个空集。

哪些语句会生成错误与警告的行为,受到当前 sql_mode 设置的高度影响。

概要

ShowErrorsStmt
SHOWERRORSShowLikeOrWhere
ShowLikeOrWhere
LIKESimpleExprWHEREExpression

示例

mysql> select invalid; ERROR 1054 (42S22): Unknown column 'invalid' in 'field list' mysql> create invalid; 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" mysql> SHOW ERRORS; +-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+ | Level | Code | Message | +-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+ | Error | 1054 | Unknown column 'invalid' in 'field list' | | 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" | +-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) mysql> CREATE invalid2; 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" mysql> SELECT 1; +------+ | 1 | +------+ | 1 | +------+ 1 row in set (0.00 sec) mysql> SHOW ERRORS; Empty set (0.00 sec)

MySQL 兼容性

TiDB 中的 SHOW ERRORS 语句与 MySQL 完全兼容。如果你发现任何兼容性差异,请报告一个 bug

另请参见

文档内容是否有帮助?