oracle迁移mysql-comment迁移

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、将查询的结果执行。