begin
declare count int default 1;
while (count<=100) do
  insert into test values(count, ‘aaa‘||count, ‘qqq‘, ‘www‘);
  update test set c3=‘aaa‘,c4=‘sss‘  where c1 = count and c2 = ‘aaa‘||count;
commit;
set count=count+1;
end while;
end
@

begin