使用MySQL存储过程连续插入多条记录
DELIMITER $$DROP PROCEDURE IF EXISTS `u1`.`FollowTmpListSave`$$CREATE DEFINER=`dev`@`%` PROCEDURE `FollowTmpListSave`(inUserId varchar(32),inParamCount int,inFollowId varchar(3000))BEGINDECLARE 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 >= inParamCountEND REPEAT;END$$DELIMITER ;
