[RESOLVED] Finnding the total of one variable when multiplied by another

[dcjones]

Hi All,

Simple question.

What type of MySQL data type should I use for stores currency amounts.

i.e £150.00 , $150.00

Many thanks if you can advice.

[NogDog]

I would store the numeric value as DECIMAL[x,2] where "x" is the maximum number of digits you would expect to need to track precisely. If you need to track multiple currency types, then that probably should be a separate column of type ENUM:

CREATE TABLE table_name (
  amount DECIMAL(10,2),
  currency ENUM('USD', 'Euro', 'UKPd', 'Yen')
);

[dcjones]

Hi NogDog,

Thanks for that, I have learned again.

Thank you