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
