"Jan Wieck" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > 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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
