Mysql8.0 查看warning信息

最新推荐文章于 2024-04-29 20:04:48 发布

xharvard

最新推荐文章于 2024-04-29 20:04:48 发布

阅读量554

点赞数 9

分类专栏： # Mysql 文章标签： mysql

本文链接：https://blog.csdn.net/xharvard/article/details/136328356

版权

Mysql 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

执行SQL的时候，如果出现warning信息，怎么查看？

执行如下语句：

mysql> alter database test02 character set utf8 collate utf8_general_ci;
Query OK, 1 row affected, 2 warnings (0.08 sec)

Query OK, 1 row affected, 2 warnings (0.08 sec)

可以使用 show warnings; 查看。

mysql> show warnings;
+---------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                                                                                                                     |
+---------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Warning | 3719 | 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| Warning | 3778 | 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.                           |
+---------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

同理，查看error信息可以使用： show errors;