1 ALTER TABLE geoloc_pays
ADD COLUMN license_plate
CHAR(4) DEFAULT NULL;
3 CREATE TEMPORARY TABLE IF NOT EXISTS tmp_update_geoloc_pays (
4 a2
CHAR(2) DEFAULT NULL,
5 code
CHAR(4) DEFAULT NULL,
10 INSERT IGNORE INTO tmp_update_geoloc_pays (a2
, code
)
215 UPDATE geoloc_pays
AS g
216 INNER JOIN tmp_update_geoloc_pays
AS t
ON (t.a2
= g.a2
)
217 SET g.license_plate
= t.code
;
219 -- vim:set syntax=mysql: