>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 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 > Unix System Administrator > Fortis Benefits > 816 881 6073 > > "Help Wanted. Seeking Telepath..." > "You Know where to apply." > > **************************************************************** > Please Note > The information in this E-mail message is legally privileged > and confidential information intended only for the use of the > individual(s) named above. If you, the reader of this message, > are not the intended recipient, you are hereby notified that > you should not further disseminate, distribute, or forward this > E-mail message. If you have received this E-mail in error, > please notify the sender. Thank you > ***************************************************************** > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <mysql- [EMAIL PROTECTED]> To > unsubscribe, e-mail > <mysql-unsubscribe- [EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php