I Wrote: > From the mysql manual: > > 'REPLACE works exactly like INSERT, except that if an old > record in the table has the same value as a new record for a > PRIMARY KEY or a UNIQUE index, the old record is deleted > before the new record is inserted. See Section 13.2.4, > "INSERT Syntax".'
It also says: Note that unless the table has a PRIMARY KEY or UNIQUE index, using a REPLACE statement makes no sense. It becomes equivalent to INSERT, because there is no index to be used to determine whether a new row duplicates another. ... John ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
