HappyNewYear_MySQL_恭贺喜年十万次_给你不一样的烟花_存储过程sql源码

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()