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;
Mysql创建临时表的方法
最新推荐文章于 2023-07-12 10:39:30 发布