SELECT
TABLE_NAME AS ‘表名’,
COLUMN_NAME AS ‘字段名’,
COLUMN_TYPE AS ‘数据类型’,
COLUMN_COMMENT from information_schema. COLUMNS
WHERE
TABLE_SCHEMA = ‘cmam_db’;
查询中运行这段代码并在查询中导出。
Navicat导出数据库
最新推荐文章于 2025-07-08 15:25:27 发布
SELECT
TABLE_NAME AS ‘表名’,
COLUMN_NAME AS ‘字段名’,
COLUMN_TYPE AS ‘数据类型’,
COLUMN_COMMENT from information_schema. COLUMNS
WHERE
TABLE_SCHEMA = ‘cmam_db’;
查询中运行这段代码并在查询中导出。