MySQL Forums
Forum List  »  Newbie

Addendum
Posted by: Commander Salamander
Date: July 14, 2005 06:57PM

I see that option 2 is out the window, since the maximum column number in a table is <3000. It seems pretty clear to me now that option number three is the correct one.

With regard to my values, I'm unsure of what field type to choose. The explanations in the documentation have me a bit confused, and I want to make sure that I choose the proper format. These numbers can range from -999.99 to 999.99. Does this mean that I should choose FLOAT(5,2)? Or DECIMAL(5,2)? What happens if I happen to add a value that exceeps 999?

Thanks again for reading (and hopefully answering) my naive questions.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.