Re: Update a row or insert if don´t exist
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
Subject
Views
Written By
Posted
12717
May 20, 2005 04:45PM
4418
June 09, 2005 12:24AM
4799
June 13, 2005 11:06PM
3261
June 14, 2005 03:32AM
Re: Update a row or insert if don´t exist
3515
June 14, 2005 06:37AM
4178
June 16, 2005 06:52AM
3707
June 16, 2005 07:44PM
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.