MySQL使用存储过程循环插入数据

delimiter //create procedure myproc() begin declare num int; set num=1; while num < 10 do insert into t_tag(tag_name, tag_desc) values(concat("tag", num), concat("tag", num)); set num=num+1;end while; end//