存储过程简单事例

BEGIN
DECLARE
num INT;

SET num = 1;

WHILE num < 100000 DO
INSERT INTO macc_user_vip (user_name, vip)
VALUES
(
concat("guochunyi", num),
inet_aton('172.16.0.0') + num
);

SET num = num + 1;

END
WHILE;

END