1 ALTER TABLE geoloc_pays
ADD INDEX (license_plate
);
3 UPDATE auth_user_md5
AS u
4 LEFT JOIN fusionax_anciens
AS f
ON (u.matricule_ax
= f.id_ancien
)
5 LEFT JOIN geoloc_pays
AS g
ON (g.license_plate
= f.Code_nationalite
)
6 SET u.nationalite
= g.a2
7 WHERE u.nationalite
IS NULL;
9 UPDATE auth_user_md5
AS u
10 LEFT JOIN fusionax_anciens
AS f
ON (u.matricule_ax
= f.id_ancien
)
11 LEFT JOIN geoloc_pays
AS g
ON (g.license_plate
= f.Code_nationalite
)
12 SET u.nationalite2
= g.a2
13 WHERE u.nationalite
!= g.a2
AND u.nationalite2
IS NULL;
15 UPDATE auth_user_md5
AS u
16 LEFT JOIN fusionax_anciens
AS f
ON (u.matricule_ax
= f.id_ancien
)
17 LEFT JOIN geoloc_pays
AS g
ON (g.license_plate
= f.Code_nationalite
)
18 SET u.nationalite3
= g.a2
19 WHERE u.nationalite
!= g.a2
AND u.nationalite2
!= g.a2
AND u.nationalite3
IS NULL;
21 ALTER TABLE geoloc_pays
DROP INDEX (license_plate
);
23 -- vim:set syntax=mysql: