Mysql创建临时表的方法

SET @id = "212,45,378";        
DROP TEMPORARY TABLE IF EXISTS tem_result;
CREATE TEMPORARY TABLE tem_result(id BIGINT(20) NOT NULL); 
SET cnt = 1+(LENGTH(@id) - LENGTH(REPLACE(@id,',','')));
WHILE i < cnt DO
SET i = i + 1;
SET result = REVERSE(SUBSTRING_INDEX(REVERSE(SUBSTRING_INDEX(@id,',',i)),',',1));
INSERT INTO tem_result(cid) VALUES (result);
END WHILE;