mysql 存储过程 循环insert数据

DELIMITER //
CREATE PROCEDURE insertmem()
BEGIN
DECLARE num INT;
SET num = 100;
WHILE num<301 DO   #301
INSERT INTO t_member(member_ID,MEMBER_NAME,CREATE_TIME)
VALUES(num,CONCAT("test",num),NOW());
SET num=num+1;
END WHILE;
END
//

CALL insertmem();   #调用