建表语句
CREATE TABLE `newyear` ( `happyId` int(8) NOT NULL AUTO_INCREMENT, `happyNewYearInfo` varchar(50) NOT NULL, `flower` varchar(50) NOT NULL, PRIMARY KEY (`happyId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
存储过程
delimiter $$ create procedure happy() begin declare i int default 0 ;while i<100000 do INSERT INTO `NewYear` VALUES (0,'虎年大吉,虎虎生威','烟火祝福,红红火火'); set i=i+1; end while; end $$ delimiter ;
使用存储过程
call happy()
送上我的虎年十万次祝福。