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]