Hi, > REPLACE is a special INSERT/UPDATE combination where you > dont specify a filter, it uses the primary key. If no existing record > exists, it INSERTs a new one, otherwise it UPDATEs an existing one.
Just a quick note - REPLACE does not do any UPDATE. It is a combination of DELETE (if the record exists) and INSERT. Also, it does not have to be the primary key - any UNIQUE index will do. Best regards, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]