Regarding mysql...
1) Are primary keys and foreign keys by default indexes for a table?
2) Do I have to use a special data other than float to allow for negative numbers,
i.e. I want to be able to enter -1.76 and be able to later do math against that
number...
Thanks,
Taylor
Taylor Lewick
From my understanding primary keys and foreign keys are indexed. Someone
correct me if I'mwrong here. And you shouldn't have to do anything else to field
besides
make it a float to usenegative numbers.
-Nick
Regarding mysql...
1) Are primary keys and foreign
keys by default indexes for a
Taylor,
Thursday, May 16, 2002, 4:22:37 PM, you wrote:
TL Regarding mysql...
TL 1) Are primary keys and foreign keys by default indexes for a table?
Yeah. Primary key is index by default. Foreign key constraints you can create only
on indexed column.
TL 2) Do I have to use a special data other