Re: mysql index question

2002-05-16 Thread Egor Egorov
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 oth

Re: mysql index question

2002-05-16 Thread Nick Stuart
>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 t

mysql index question

2002-05-16 Thread Taylor Lewick
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 U