Right, I think I've decided to add a new ID field as the primary key which is an auto incrementing integer. This means I can't use get() to check whether the items already exist in the database but I can just use a select statement instead I think. Before I make big changes to the structure of my tables I just wanted to make sure that this is a sensible thing to do. Any comments?
I know that if I add the field to the existing database I wont be able to fill the new ID field automatically - can I dump the table and then import it to fill the values?
Thanks, Laura.
I know that if I add the field to the existing database I wont be able to fill the new ID field automatically - can I dump the table and then import it to fill the values?
Thanks, Laura.