http://dev.mysql.com/doc/refman/5.0/en/replace.html
Or as previously mentined:
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
> > -Original Message-
> > From: Ron Piggott [mailto:ron@actsministries.org]
> > Sent: Saturday, September 05, 2009 1:19 PM
> > To: php-
Thanks
- Original Message -
From: "Waynn Lue"
To: "Ron Piggott" ;
Sent: Saturday, September 05, 2009 4:45 PM
Subject: Re: [PHP-DB] UPDATE instead of INSERT INTO
INSERT INTO ON DUPLICATE KEY UPDATE is what you're looking for.
On 9/5/09, Ron Piggott wro
INSERT INTO ON DUPLICATE KEY UPDATE is what you're looking for.
On 9/5/09, Ron Piggott wrote:
> I made an application which lets users rate web site content. At the heart
> of the application is this mySQL query:
>
> INSERT INTO `ratings` ( `reference` , `content_type` , `content_reference` ,
> `