MySQL查询全链路排序规则

最新推荐文章于 2024-07-20 16:33:27 发布

diffiii

最新推荐文章于 2024-07-20 16:33:27 发布

阅读量595

点赞数 5

分类专栏： MySQL 文章标签： mysql 数据库

本文链接：https://blog.csdn.net/qq_45796594/article/details/139445103

版权

MySQL 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

set @v1=(select VARIABLE_VALUE from performance_schema.GLOBAL_VARIABLES where VARIABLE_NAME='character_set_client' limit 1);
set @v2=(select VARIABLE_VALUE from performance_schema.GLOBAL_VARIABLES  where VARIABLE_NAME='character_set_connection' limit 1);
set @v4=(select VARIABLE_VALUE from performance_schema.GLOBAL_VARIABLES where VARIABLE_NAME='character_set_server' limit 1);
set @v5=(select VARIABLE_VALUE from performance_schema.GLOBAL_VARIABLES where VARIABLE_NAME='character_set_results' limit 1);
select 
@v1 as '客户端数据使用的字符集',
@v2 as '客户端连接字符集',
@v4 as 'MySQL服务器字符集',
@v5 as 'MySQL查询结果字符集',
a.SCHEMA_NAME as '数据库',
a.DEFAULT_CHARACTER_SET_NAME as '数据库字符集',
a.DEFAULT_COLLATION_NAME as '数据库排序规则',
b.table_name as '表名',
b.table_collation as '表排序规则',
c.COLUMN_NAME as '字段名',
c.CHARACTER_SET_NAME as '字段字符集',
c.COLLATION_NAME as '字段排序规则',
c.COLUMN_TYPE  as '数据类型'
from information_schema.SCHEMATA  a
left join information_schema.tables b on b.table_schema=a.SCHEMA_NAME
left join information_schema.columns c on c.TABLE_SCHEMA=a.SCHEMA_NAME and c.table_name=b.table_name
where a.SCHEMA_NAME='testdb';