MySQL 创建存储过程

CREATE PROCEDURE insert_uid_pms()
BEGIN
     DECLARE i int default 1;
     WHILE(i < 100) DO
       insert into t_pms(folder,uid,fromid,message)
values(0,i,1,' 牛年吉祥！“单人游戏段位”新鲜出炉了！回帖参与统计就有奖励拿哦，快来看看你的水平吧！<a href="http://www.miduo.com/bbs/viewthread?tid=306">点此参与</a>');
        SET i = i+1;
    END WHILE;
END

call insert_uid_pms();