[CDBI] Working with tables without primary keys?

Left to My Own Devices nazareth at eye-of-newt.com
Tue Nov 8 02:49:18 GMT 2005


>  > 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 --




More information about the ClassDBI mailing list