note 73898 deleted from function.mysql-insert-id by bobby
| From: | bobby@php.net | Date: | Wed, 14 Mar 2007 23:01:20 +0000 |
| Subject: | note 73898 deleted from function.mysql-insert-id by bobby | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-124464@lists.php.net to get a copy of this message | ||
Note Submitter: sunnyday at pisem dot net
----
In comment to athies at gmail dot com
21-Jul-2005 05:36
Yes, REPLACE works, cuz according to SQL-manual:
REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a
new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted.
See Section 13.2.4, âINSERT Syntaxâ.
That's a pity that it doesn't even get a mention in the PHP-manual.