Commit | Line | Data |
---|---|---|
ce0b2c6f | 1 | INSERT INTO profile_education (id, pid, grad_year, entry_year, eduid, degreeid, flags) |
aafd3025 | 2 | SELECT 100, u.user_id, u.promo_sortie, u.promo, e.id, d.id, 'primary' |
d0293d9b | 3 | FROM #x4dat#.auth_user_md5 AS u |
aafd3025 SJ |
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"); | |
fb2c09c9 | 6 | |
75036b0f | 7 | UPDATE profile_display AS d |
ce0b2c6f | 8 | INNER JOIN profile_education AS e ON (d.pid = e.pid) |
75036b0f SJ |
9 | SET d.promo = CONCAT("X", entry_year) |
10 | WHERE FIND_IN_SET('primary', e.flags); | |
fb2c09c9 SJ |
11 | |
12 | -- vim:set syntax=mysql: |