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
原文：http://www.cnblogs.com/guochunyi/p/4690250.html