On Tue, 2008-01-08 at 11:21 +0100, H.Merijn Brand wrote: > On Tue, 08 Jan 2008 04:43:51 -0500, num...@deathwyrm.com wrote: > > > Philip Newton wrote: > > > It even lets you mix the two with REPLACE INTO, which will do an > > > INSERT, unless the record is already present, in which case it'll do > > > an UPDATE instead. > > > > Rather, it does a DELETE then an INSERT. Which I'd rate slightly more > > hateful, since it's another entry towards any auto-insert fields running > > out of numbers. But it probably depends on the situation. > > And delete won't work if it is a referenced record, where update would.
MySQL has constraints like that? I know the next version to the one that I may or may not have installed probably does, but that's a different hate. > This is just screaming for cursing users. More hate >