MySQL Forums
Forum List  »  InnoDB

Re: Update a row or insert if don´t exist
Posted by: Arjen Lentz
Date: June 14, 2005 06:37AM

Andrew Gilfrin wrote:
> is there any more information on "ON DUPLICATE KEY" as I can't seem to get it to work and it
> doesn't seem to be in the documentation

It sure is in the docs: http://dev.mysql.com/doc/mysql/en/insert.html
But syntactically it's really easy anyway: just a regular INSERT statement, followed by those keywords, followed by a regular UPDATE statement.

Regards, Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.

Follow us at http://openquery.com/blog/ & http://twitter.com/openquery

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Update a row or insert if don´t exist
3497
June 14, 2005 06:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.