1 INSERT INTO profile_education (id, uid
, grad_year
, entry_year
, eduid
, degreeid
, flags
)
2 SELECT 100, user_id
, promo_sortie
, promo
, 20, 2, 'primary'
5 CREATE TABLE profile_display (
6 uid
INT(11) NOT NULL DEFAULT 0,
7 promo_display
VARCHAR(255) DEFAULT '' NOT NULL,
11 INSERT IGNORE INTO profile_display (uid
, promo_display
)
12 SELECT uid
, CONCAT("X", entry_year
)
13 FROM profile_education
14 WHERE FIND_IN_SET('primary', flags
);
16 -- vim:set syntax=mysql: