oracle迁移到mysqlmysql拼接脚本重命名表名

oracle迁移到mysql–mysql重命名表名的拼接脚本

由于mysql8.0一开始建成对大小写敏感,所以目前打算统一为小写,而之前配置了ogg默认*号匹配的是大写,所以考虑先将表名都改成大写后同步,等同步完成后再改回小写表名:

由于涉及表多,所以通过拼接的方式生成重命名表名的语句,

mysql> select CONCAT('alter table ',table_name,' rename to ',upper(table_name),';') from information_schema.tables where table_schema='resdb'; +------------------------------------------------------------------------------------+ | CONCAT('alter table ',table_name,' rename to ',upper(table_name),';') | +------------------------------------------------------------------------------------+ | alter table ADDRESSINFO rename to ADDRESSINFO; | | alter table ADDR_SEGM rename to ADDR_SEGM; | | alter table AN_COMBINER rename to AN_COMBINER; | | alter table AN_COMBINER_CONN rename to AN_COMBINER_CONN; | | alter table AN_COMBINER_PORT rename to AN_COMBINER_PORT; | | alter table AN_LAN_IPTV_PORT rename to AN_LAN_IPTV_PORT; | | alter table AN_LOGIC_CONN rename to AN_LOGIC_CONN; | | alter table AN_NE_DEVICE rename to AN_NE_DEVICE; | | alter table AN_ODN rename to AN_ODN; | | alter table AN_ODN_CARD rename to AN_ODN_CARD; | | alter table AN_ODN_FINISHRENOVATE_STATUS rename to AN_ODN_FINISHRENOVATE_STATUS; |