建立虚拟表
CREATE TEMPORARY TABLE u (
new_assignment VARCHAR ( 66 ),
key_id VARCHAR ( 64 ),
is_del VARCHAR ( 1 ),
PRIMARY KEY ( key_id ));
将查询出的数据插入临时表
INSERT INTO u ( new_assignment, key_id, is_del )
SELECT new_assignment, key_id, is_del FROM user_assign WHERE new_assignment = 1 AND is_del = 0 GROUP BY key_id;