select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT
from information_schema.columns where TABLE_SCHEMA='数据库名称'
数据库导出数据库字典
最新推荐文章于 2024-07-27 17:38:38 发布
select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT
from information_schema.columns where TABLE_SCHEMA='数据库名称'