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-02 20:02:23 发布