在TRIGGER中 set @i=1; while @i<=3 do insert into b values(new.id,new.name) set @i=@i+1; end while;
详细说明,试试 set @i=1; while @i<=3 do insert into b values(new.id,new.name) insert into C values(new.id,new.name) insert into D values(new.id,new.name) set @i=@i+1; end while;
set @i=1;
while @i<=3 do
insert into b values(new.id,new.name)
set @i=@i+1;
end while;
set @i=1;
while @i<=3 do
insert into b values(new.id,new.name)
insert into C values(new.id,new.name)
insert into D values(new.id,new.name)
set @i=@i+1;
end while;