DELIMITER $$
DROP PROCEDURE IF EXISTS `u1`.`FollowTmpListSave`$$
CREATE DEFINER=`dev`@`%` PROCEDURE `FollowTmpListSave`(inUserId varchar(32),inParamCount int,inFollowId varchar(3000))
BEGIN
DECLARE i INT(8) DEFAULT 0;
REPEAT SET i = i + 1;
INSERT INTO TB_FOLLOWTMP(userId,followId) VALUES (inUserId,TRIM(SUBSTRING_INDEX(SUBSTRING_INDEX(inFollowId, ',', i), ',', -1)));
UNTIL i >= inParamCount
END REPEAT;
END$$
DELIMITER ;
使用MySQL存储过程连续插入多条记录
最新推荐文章于 2024-06-04 09:48:22 发布