mysql触发器

DELIMITER |
CREATE trigger UpdateRealtime1 after insert on curcevalue
for  each row
begin
   set @count=0;
   select count(*) from realtimedata where vid=new.CurceKey into @count;
   if@count>0 then
    update realtimedata set realvalue=new.curcevalues where vid= new.CurceKey;
   else
    insert into realtimedata(vid,realvalue,realtime)values (new.CurceKey,new.curcevalues,new.CurceDate);
   end if; 
end
|
DELIMITER ;