Originally Posted by Sirdude
then you replace, if already there, else it inserts

Ah, that way you can also skip delete query #1.

But what if somebody changed the WATCH_NOTIFY_IMMEDIATE value to 0, wouldn't it add a new record?

edit: REPLACE INTO will actually perfo...rm an update (as the name suggests).. Seeing this there would not be must advantage in using replace into.

Last edited by blaaskaak; 09/03/2007 6:54 AM. Reason: blaaskaak did some surfing reading up the replace into stuff
[Linked Image from siemons.org]