1 INSERT INTO profile_education (id, uid
, grad_year
, entry_year
, eduid
, degreeid
, flags
)
2 SELECT 100, u.user_id
, u.promo_sortie
, u.promo
, e.
id, d.
id, 'primary'
3 FROM auth_user_md5
AS u
4 LEFT JOIN profile_education_enum
AS e
ON (e.abbreviation
= "X")
5 LEFT JOIN profile_education_degree_enum
AS d
ON (d.
degree = "Ingénieur");
7 UPDATE profile_display
AS d
8 INNER JOIN profile_education
AS e
ON (d.pid
= e.uid
)
9 SET d.promo
= CONCAT("X", entry_year
)
10 WHERE FIND_IN_SET('primary', e.flags
);
12 -- vim:set syntax=mysql: