select
concat(table_name,">>",group_concat(COLUMN_NAME)) t
from information_schema.COLUMNS where table_name
in( select table_name from information_schema.tables where table_schema='databasename'
)
GROUP BY table_name order by table_name
查询库中所有表中的字段
最新推荐文章于 2024-01-18 00:37:58 发布