阅读背景:

mysql事件执行存储过程

来源:互联网 

CREATE PROCEDURE InitializationData()
BEGIN
update yt_products set number=number+100 where id=1;
update yt_products set number=number+100 where id=2;
update yt_products set number=number+100 where id=3;
update yt_products set number=number+50 where id=4;
update yt_products set number=number+1 where id=5;
update yt_products set number=number+1 where id=6;
update yt_products set number=number+1 where id=7;
update yt_products set number=number+1 where id=8;
update yt_products set number=number+10 where id=9;
update yt_products set number=number+10 where id=10;
update yt_products set number=number+10 where id=11;
update yt_products set number=number+10 where id=12;
update yt_products set number=number+5000 where id=13;
update yt_products set number=number+6000 where id=14;
END;CREATE PROCEDURE InitializationData()
BEGIN
update




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: