On 06/16/04 09:53 John Nichel spoke:
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'

Ok, a primary key is unique, right?

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to