– 迁移数据 从一张表复制到另外一张表,并改变某些值
INSERT INTO dabase1.table1 t1(`id`,`name`,`status`)
SELECT `id`,`name`,(CASE `status` WHEN '有效' THEN 'active' ELSE 'inactive' END)`status` FROM dabase2.table2 t2;
– 迁移数据 从一张表复制到另外一张表,并改变某些值
INSERT INTO dabase1.table1 t1(`id`,`name`,`status`)
SELECT `id`,`name`,(CASE `status` WHEN '有效' THEN 'active' ELSE 'inactive' END)`status` FROM dabase2.table2 t2;