DROP PROCEDURE IF EXISTS add_t_book;
DELIMITER //
CREATE PROCEDURE add_t_book()
BEGIN
DECLARE i INT DEFAULT 0;
REPEAT
INSERT INTO t_book VALUES(CONCAT('zhangsanaaaaxx',i),CONCAT('zhangsan',i),34,"2013-01-22");
SET i=i+1;
UNTIL i>=1000
END REPEAT;
END//
DELIMITER ;
DELIMITER //
CREATE PROCEDURE test()
BEGIN
DECLARE i INT DEFAULT 0;
WHILE i<100 DO
INSERT INTO payout(userId,payOutName,payOutMoney,payOutDate) VALUES(1,"zhangsan",1,"2013-01-22");
SET i=i+1;
END WHILE;
END;
//
DELIMITER ;