MySQL 数据库查询字段名称、字段解释、中文名称、表名称、表注释等SELECT case when locate('_',column_name) >0 then concat(lower(left(column_name,locate('_',column_name)-1)),upper(substring(column_name,locate('_',column_name)+1,1)),lower(substring(column_name,locate('_',column_name)+2))) else lower(column_name) end as column_name, data_type, column_comment, table_name, (select table_comment from information_schema.tables where table_schema='oop'and table_name = information_schema.columns.table_name ) as table_commentFROM information_schema.columns WHERE table_name in (select distinct table_name from information_schema.columns where table_schema = 'oop')ORDER BY ORDINAL_POSITION,table_name;