Re: Monetary field in MySQL
| From: | Rolf Brusletto | Date: | Fri, 23 May 2003 16:08:57 +0000 |
| Subject: | Re: Monetary field in MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27994@lists.php.net to get a copy of this message | ||
Shaun -
you can use a float type.
ALTER TABLE
blah ADD aMoneyField FLOAT(6,2) DEFAULT "0.00"
Hope it helps =)
Rolf Brusletto
http://www.phpExamples.net
shaun wrote:
*This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, how can I have a field in MySQL that represents a monetary value i.e. it always has 2 zeros after the decimal point? Thanks for your help