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 DOSET i = i + 1;SET result = REVERSE(SUBSTRING_INDEX(REVERSE(SUBSTRING_INDEX(@id,',',i)),',',1));INSERT INTO tem_result(cid) VALUES (result);END WHILE;