SELECT
a.TABLE_NAME '表名',
a.TABLE_COMMENT '数据表名称',
group_concat( b.COLUMN_comment )
FROM
information_schema.TABLES a
LEFT JOIN information_schema.COLUMNS b ON a.table_name = b.TABLE_NAME
WHERE
a.table_schema = '数据库名字'
-- AND a.TABLE_COMMENT IS NOT NULL
AND a.TABLE_COMMENT != 'VIEW'
AND a.TABLE_NAME NOT LIKE 'act_%'
AND a.TABLE_NAME NOT LIKE 'sys_%'
AND a.TABLE_NAME NOT LIKE 'bpm_%'
AND a.TABLE_NAME NOT LIKE 'org_%'
AND a.TABLE_NAME NOT LIKE 'bus_%'
AND a.TABLE_NAME NOT LIKE 'form_%'
AND a.TABLE_NAME NOT LIKE 'test_%'
AND a.TABLE_NAME NOT LIKE '%_copy%'
AND a.TABLE_NAME NOT LIKE 'dsrw'
and a.TABLE_NAME NOT in ('m_drpz','tm_xsinvuice','m_xxdcb','t_db_link','t_order','t_prudct','gsbm','db_uploader')
AND b.COLUMN_comment NOT LIKE '备注%'
AND b.COLUMN_comment NOT LIKE '删除%'
AND b.COLUMN_comment NOT LIKE '修改%'
AND b.COLUMN_comment NOT LIKE '创建%'
AND b.COLUMN_comment NOT LIKE '主键'
GROUP BY
a.TABLE_NAME
ORDER BY
a.TABLE_NAME,
b.ordinal_position
查询mysql数据库中所有表和字段
最新推荐文章于 2024-07-22 22:50:39 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)