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(); #调用
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(); #调用