SELECT b.TABLE_SCHEMA,a.TABLE_NAME,b.TABLE_COMMENT,a.column_name from
(select TABLE_NAME,column_name from information_schema.columns where table_schema='gils_dev_wms' and table_name in (SELECT TABLE_NAME FROM information_schema.tables
where table_schema='指定数据库')) a
left JOIN (SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_COMMENT FROM information_schema.tables
where table_schema='gils_dev_wms') b on a.TABLE_NAME = b.TABLE_NAME
MySql中查询特定数据库下的所有表描述和字段
最新推荐文章于 2024-07-11 21:41:59 发布