
March 13th, 2000, 05:10 PM
|
|
Contributing User
|
|
Join Date: Oct 1999
Location: Annapolis, Maryland US
Posts: 113
Time spent in forums: < 1 sec
Reputation Power: 14
|
|
|
Does the "books" column have a complementary unique key column associated with it, e.g. "book_id" where you use an auto_increment integer or the ISBN to uniquely identify it? If that is the case then that column should be the primary key. If not, then you could make the "book" column the primary key if there would be no duplicate book names in the database (risky...) Suggest putting in a primary key column to uniquely identify each and every book and then use an INDEX on the book column to optimize search performance.
|