[thelist] SQL - Field Types...

[Gary Bland]

Dave Stevens wrote:
> --
> [ Picked text/plain from multipart/alternative ]
> Hi all,
>
> I have a table in a MySql database, which contains a field, amongst others, called "Price" which is not just a clever name - it contains the price of a product.
>
> I need to be able to add up prices on an orderform later on, so what field type would be best for this field?
>
> I saw DECIMAL, is this a good option?

no use float(10,2) default 0.00

HTH
Gary




--
Gary Bland
StarChaser Web Architecture
http://star-chaser.com
Building Tomorrow's World Today