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
