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. This is just screaming for cursing users. More hate -- H.Merijn Brand Amsterdam Perl Mongers (http://amsterdam.pm.org/) using & porting perl 5.6.2, 5.8.x, 5.10.x on HP-UX 10.20, 11.00, 11.11, & 11.23, SuSE 10.1 & 10.2, AIX 5.2, and Cygwin. http://qa.perl.org http://mirrors.develooper.com/hpux/ http://www.test-smoke.org http://www.goldmark.org/jeff/stupid-disclaimers/
