Commit | Line | Data |
---|---|---|
b8ed94e9 SJ |
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: |