select table_name,COLUMN_NAME 字段名,
column_comment 字段说明,
column_type 字段类型,
column_key 约束 from information_schema.columns
where table_schema = 'prod'
MySQL查看库的所有表字段和注释
最新推荐文章于 2024-07-20 16:33:27 发布
select table_name,COLUMN_NAME 字段名,
column_comment 字段说明,
column_type 字段类型,
column_key 约束 from information_schema.columns
where table_schema = 'prod'