Laercio Xisto Braga Cavalcanti wrote:
When you use the replace command if the row does not exist it is inserted.
MySQL Reference Manual:
Section 14.1.6
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
Read what you quoted. The old record is *deleted* if it exists, and then a new record is inserted.
So he wouldn't be able to get the incremented count.
-- Keith Ivey <[EMAIL PROTECTED]> Washington, DC
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
