1、将oracle中的user_col_comments中的表和数据迁移到mysql中；
2、使用以下语句查询出comment的语句
SELECT CONCAT('ALTER TABLE ',c.table_name,' MODIFY COLUMN ',c.column_name,' ',c.column_type,' COMMENT ','\'',c.comments,'\'',';') AS statements
FROM
(
SELECT a.table_name,a.column_name,column_type,a.comments
FROM user_col_comments AS a,
(SELECT table_name,column_name,column_type
FROM information_schema.columns
WHERE table_schema='wms_tangram_jlt'
ORDER BY table_schema,table_name ) AS b
WHERE a.table_name=b.table_name AND a.column_name=b.column_name AND a.comments IS NOT NULL ) c
3、将查询的结果执行。
