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