利用存储过程_MySQL

open wu
fetch next from wu into @pro
while @@fetch_status=0
begin
select @mm=sum([cost]) from mytest where [product]=@pro
delete from mytest where [product]=@pro
insert into mytest ([product],[cost]) values(@pro,@mm)

fetch next from wu into @pro
end
close wu
deallocate wu
GO
我们可以使用作业进行相应的数据的更新