SELECT TABLE_NAME ‘表名‘,
COLUMN_NAME AS ‘字段名‘,
COLUMN_KEY AS ‘是否主键‘,
IS_NULLABLE AS ‘是否为空‘,
COLUMN_TYPE AS ‘字段类型‘,
COLUMN_COMMENT AS ‘字段说明‘
from information_schema.columns WHERE TABLE_SCHEMA=‘lj_xc_publicity‘;

Mysql导出数据字典