Navicat 快速生成数据字典
- 直接上sql语句
SELECT
COLUMN_NAME AS '字段名称',
COLUMN_TYPE AS '字段类型',
COLUMN_COMMENT AS '备注'
FROM
information_schema.COLUMNS
WHERE
table_schema = 'huoying' #表所在数据库
AND table_name = 'lc_user_basic';#你要查的表
Navicat 快速生成数据字典
SELECT
COLUMN_NAME AS '字段名称',
COLUMN_TYPE AS '字段类型',
COLUMN_COMMENT AS '备注'
FROM
information_schema.COLUMNS
WHERE
table_schema = 'huoying' #表所在数据库
AND table_name = 'lc_user_basic';#你要查的表