mysql表字段中文查询

1:右键表数据库,选择“在数据库中查询”

2: 选择连接,数据库,查询中文

 3:执行sql查询出拼接sql,复制第3列到一个新的查询去执行,需要删除最后一个⚠️union⚠️

SELECT 
c.TABLE_NAME as '表名',
c.COLUMN_NAME as '字段' ,
CONCAT("SELECT '",c.TABLE_NAME ,"' as TABLE_NAME ,'",c.COLUMN_NAME,"' as COLUMN_NAME ,'",c.COLUMN_COMMENT,"' as COLUMN_COMMENT ,count(1) from ",c.TABLE_NAME," where ",c.COLUMN_NAME," like '%马迹山%' or ",c.COLUMN_NAME," like '%衢山%' union ")
from  information_schema.columns c
LEFT JOIN information_schema.TABLES  t on c.TABLE_SCHEMA = t.TABLE_SCHEMA and c.TABLE_NAME = t.TABLE_NAME 
where 1=1  
-- 数据库名
and c.TABLE_SCHEMA ='数据库名'
-- 表名
and c.TABLE_NAME in( 
"表名"
) and c.DATA_TYPE ='varchar'