views:

1392

answers:

3

I want to store values in a bunch of currencies and I'm not too keen on the imprecise nature of floats. Being able to do math on them directly in queries is also a requirement.

Is Decimal the way to go here?

+10  A: 

Decimal is the best way to go.

You can still do math within the queries.

bobwienholt
A: 

I concurr, decimal is the way to go. Never had problems with it.

Nikola Stjelja
This isn't a forum. If you agree with an answer, vote it up. "I agree" isn't exactly the purpose of the "answers" portion. No offense meant.
Jonathan Sampson
A: 

my question is that how i can make a column in mysql table as(productno and it should have the data type 4alpha and 4numeric ) and it should be primary_key plz email

Faisal