Or the more standard INSERT... ON DUPLICATE KEY UPDATE
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
Shaunak Kashyap
Senior Web Developer
WPT Enterprises, Inc.
5700 Wilshire Blvd., Suite 350
Los Angeles, CA 90036
Direct: 323.330.9870
Main: 323.330.9900
www.worldpokertour.com
Confidentiality Notice: This e-mail transmission (and/or the
attachments accompanying) it may contain confidential information
belonging to the sender which is protected. The information is intended
only for the use of the intended recipient. If you are not the intended
recipient, you are hereby notified that any disclosure, copying,
distribution or taking of any action in reliance on the contents of this
information is prohibited. If you have received this transmission in
error, please notify the sender by reply e-mail and destroy all copies
of this transmission.
-Original Message-
From: Greg Donald [mailto:[EMAIL PROTECTED]
Sent: Friday, March 31, 2006 2:38 PM
To: mysql@lists.mysql.com
Subject: Re: Update or insert with a single SQL statement?
On 3/31/06, Brian Dunning [EMAIL PROTECTED] wrote:
I have a really simple two-column database:
domain_name (primary key)
timestamp
I'm trying to keep track of the referrer of every visit to a web
site, and I'm looking for a single SQL statement (since my ISP
limits
the total number of calls I can make in a day) that will either
insert a new record if the referring domain is not already in there,
or simply update the timestamp if the referring domain is already in
there.
Possible?
REPLACE INTO
http://dev.mysql.com/doc/refman/5.0/en/replace.html
--
Greg Donald
Zend Certified Engineer
MySQL Core Certification
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]