SELECT
a.TABLE_SCHEMA AS '数据库',
a.TABLE_NAME AS '表',
a.COLUMN_NAME AS '字段',
a.COLUMN_TYPE AS '字段类型',
a.CHARACTER_SET_NAME AS '原字符集',
a.COLLATION_NAME AS '原排序规则',
a.COLUMN_COMMENT
# CONCAT('sum(',a.COLUMN_NAME,') AS `',a.COLUMN_COMMENT,'`,')
FROM information_schema.`COLUMNS` AS a
where TABLE_NAME ='app_supply_claim_instock_saas'
sql快速翻译字段
于 2022-05-18 11:38:19 首次发布