| 1 | CREATE TEMPORARY TABLE IF NOT EXISTS tmp_update_fusionax_anciens ( |
| 2 | good CHAR(4) DEFAULT NULL, |
| 3 | bad CHAR(4) DEFAULT NULL, |
| 4 | PRIMARY KEY(bad), |
| 5 | UNIQUE KEY(good) |
| 6 | ) CHARSET=utf8; |
| 7 | |
| 8 | INSERT IGNORE INTO tmp_update_fusionax_anciens (bad, good) |
| 9 | VALUES ('TC', 'CAM'), |
| 10 | ('SH', 'CN'), |
| 11 | ('R', 'RO'), |
| 12 | ('TW', 'RC'), |
| 13 | ('TG', 'RT'), |
| 14 | ('U', 'ROU'), |
| 15 | ('KP', 'ROK'), |
| 16 | ('CRO', 'HR'), |
| 17 | ('UKR', 'UA'), |
| 18 | ('AM', 'ARM'), |
| 19 | ('CS', 'CZ'), |
| 20 | ('SU', 'RUS'), |
| 21 | ('LET', 'LV'), |
| 22 | ('MDA', 'MD'); |
| 23 | |
| 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; |
| 27 | |
| 28 | -- vim:set syntax=mysql: |