1 CREATE TEMPORARY TABLE IF NOT EXISTS tmp_update_fusionax_anciens (
2 good
CHAR(4) DEFAULT NULL,
3 bad
CHAR(4) DEFAULT NULL,
8 INSERT IGNORE INTO tmp_update_fusionax_anciens (bad
, good
)
24 UPDATE fusionax_anciens
AS f
25 INNER JOIN tmp_update_fusionax_anciens
AS t
ON (f.Code_nationalite
= t.bad
)
26 SET f.Code_nationalite
= t.good
;
28 -- vim:set syntax=mysql: