导出表名及备注
SELECT
COLUMN_NAME,
COLUMN_COMMENT
FROM
INFORMATION_SCHEMA. COLUMNS
WHERE
table_name ='表名'
AND table_schema ='库名'
查询库所有表;显示表名和备注
SELECT
TABLE_NAME,
TABLE_COMMENT
FROM
INFORMATION_SCHEMA. TABLES
WHERE
table_schema ='venus'
DMP 字典表&& 国际化数据维护
维护国际化语言数据-关于DMP的:
select * from t_chaos_i18n_language_item a where a.item_code like 'lang.venus.%'
维护字典数据:
select * from t_chaos_param_config where group_code ='venus'select * from t_chaos_dict_val a where a.sys_source ='DMP';