存储过程循环插入数据，员工号从002累加到500

CREATE PROCEDURE proc_buildata(IN loop_times INT)

BEGIN

DECLARE var INT DEFAULT 0;

DECLARE t INT DEFAULT 0;

WHILE var<loop_times DO

SET var=var+1;

while var<10 do
set t=concat('00',var);

end while;

INSERT INTO restaurant_staff (merchant_id,restaurant_id,password,salt,staff_no,role,is_expired,create_at) VALUES (111,222,'xxx','xxx',t,'s',0,CURRENT_TIMESTAMP());

END WHILE;

END

我想staff_no号从001插入到500 怎么做呢各位高好

http://www.cnblogs.com/blueskyc/archive/2010/01/11/1644096.html