ALTER TABLE `payment_identity` MODIFY COLUMN `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin not NULL COMMENT ”;
ALTER TABLE `payment_identity`[……]
SELECT concat(‘rename table loanbiz.’,TABLE_NAME,’ to acrc.’,TABLE_NAME,’;’) FROM INFORMATION_SCHEMA.TABLES WHERE table_schema=’loanbiz’ into outfile[……]