upgrade/merge-0.0.1/04_nationalities.sql

   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: