個人備份——mysql預存程序

/*參數：插入記錄的起始ID，客戶ID，記錄數，初始使用者名稱*/
DELIMITER $$
CREATE PROCEDURE batchInsert(IN init INT , IN cid INT , IN loops INT , IN username VARCHAR(64))
BEGIN
DECLARE myid INT;
DECLARE myname VARCHAR(64);
DECLARE num INT;
SET myid = init;
SET myname = username;
SET num = 1;
WHILE num <= loops DO
SET myname = CONCAT(username , CONVERT(myid , CHAR));
/*往使用者表插入一個使用者*/
INSERT INTO user (id , cid , NAME , realname , photo , experience , register_date , modify_date) 
VALUES (myid , cid , myname , myname , 'www.baidu.com' , 1200.00 , NOW() , NOW());
/*往經驗表中插入該使用者的經驗記錄*/
INSERT INTO user_experience (cid , NAME , qid , aid , exp_reg , tags , create_date , modify_date , exp_status)
VALUES (cid , myname , 10000 , 10000 , 3.14 , 'ab,cd,ee' , NOW() , NOW() , 2);
SET num = num+1;
SET myid = myid+1;
END WHILE;
END $$

CALL batchInsert(1,1,5000,'aaa');
CALL batchInsert(5001,3,5000,'bbb');