Re: update count
| From: | Bob Lockie | Date: | Wed, 16 Jun 2004 14:21:13 +0000 |
| Subject: | Re: update count | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34815@lists.php.net to get a copy of this message | ||
On 06/16/04 09:53 John Nichel spoke:
Bob Lockie wrote:Ok, a primary key is unique, right?What is the best way to only do an update if it going to update only one row? I want to protect my code so that it won't accidentally update more than one row. I can do a select first but there must be an easier way. :-)UPDATE thisDB.thisTable SET thisTable.thisColumn = 'thisValue' WHERE thisTable.uniqueColumn = 'someUniqueValue'