Re: update count
| From: | John Nichel | Date: | Wed, 16 Jun 2004 13:53:47 +0000 |
| Subject: | Re: update count | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-188394@lists.php.net to get a copy of this message | ||
Bob Lockie wrote:
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' -- John C. Nichel KegWorks.com 716.856.9675 john@kegworks.com