"Jan Wieck" <JanWieck(at)Yahoo(dot)com> wrote in message
news:200106061506(dot)f56F6dV01843(at)jupiter(dot)us(dot)greatbridge(dot)com(dot)(dot)(dot)
> mlw wrote:
> > [...]
> > REPLACE into table set xx=yy, ww = zz where ID = fubar;
> >
> > A MUCH better solution!
>
> Please solve the trigger problem at least theoretical before
> claiming that mySQL is that MUCH better. And please don't
> solve it by ripping out trigger support :-)
>
for INSERT OR REPLACE into table ...
if the record was not there, fire the insert trigger
else
delete the row (fire delete trigger)
insert the new row (fire the insert trigger)
fi
semantically no other way, I think
Dale.