查询MySQL表的字段的注释

select
COLUMN_NAME 字段名,
column_comment 字段说明,
ordinal_position 排序
from information_schema.columns t
where table_schema = 'nnvk'
and table_name = 'vk_radiation_source' ORDER BY ordinal_position asc;

插入注释：

INSERT INTO sys_table_column_comment
select
'vk_repair',
COLUMN_NAME 字段名,
ordinal_position 排序,
column_comment 字段说明
from information_schema.columns t
where table_schema = 'nnvk'
and table_name = 'vk_repair' and column_comment <> '' ORDER BY ordinal_position asc