# 显示警告和错误

__*显示警告和错误*__
__*SHOW WARNINGS*__
__*SHOW ERRORS*__

+ `SHOW WARNINGS` 和 `SHOW ERRORS` 
```8
mysql> create table test.bt2 (id bigint key auto_random);
Query OK, 0 rows affected, 1 warning (0.09 sec)
mysql> show warnings;
+-------+------+---------------------------------------------------------+
| Level | Code | Message                                                 |
+-------+------+---------------------------------------------------------+
| Note  | ~!@1105@!~ | Available implicit allocation times: 288230376151711743 |
+-------+------+---------------------------------------------------------+
mysql> select invalid;
ERROR ~!@1054@!~ (42S22): Unknown column 'invalid' in 'field list'
mysql> show errors;
+-------+------+------------------------------------------+
| Level | Code | Message                                  |
+-------+------+------------------------------------------+
| Error | ~!@1054@!~ | Unknown column 'invalid' in 'field list' |
+-------+------+------------------------------------------+
mysql> show warnings;
+-------+------+------------------------------------------+
| Level | Code | Message                                  |
+-------+------+------------------------------------------+
| Error | ~!@1054@!~ | Unknown column 'invalid' in 'field list' |
+-------+------+------------------------------------------+
```
--------------------------------------------------------------------
TiDB 与 MySQL 中的错误码兼容,大多数情况下返回的错误码与 MySQL 相同。

请参阅上的错误代码的完整列表`https://docs.pingcap.com/tidb/stable/error-codes`。而且,某些错误代码代表内部错误。通常,TiDB 会处理错误,而不是将其返回给用户。