Re: [CDBI] Working with tables without primary keys?

> > Given a table like this:

>  > Given a table like this:
>>
>>  +--------+----------+
>>  | foo_id | foo_name |
>>  +--------+----------+
>>  |      0 | bar-1    |
>>  |      8 | bar-2    |
>>  |      3 | bar-3    |
>>  |      8 | bar-4    |
>>  |      7 | bar-5    |
>>  |      4 | bar-6    |
>>  |      7 | bar-7    |
>>  |      4 | bar-8    |
>>  |      0 | bar-9    |
>>  +--------+----------+
>
>The primary key of that table seems to be (foo_id, foo_name).  At least
>there are no dupes in this sample data.  Just set that as your primary
>key.

foo_name by itself is unique in this sample. If it's guaranteed to be 
unique, you could use it as the key.

        -- 
        Aneel Nazareth -- http://eye-of-newt.com/nazareth --

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi