I don't think you can have a relation (table) without a unique key. Either a
single field or a unique relation between 2 or more fields is necessary for
the table.

Franciccio


"Bob Lockie" <[EMAIL PROTECTED]> ha scritto nel messaggio
news:[EMAIL PROTECTED]
> 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