Not really a MySQL problem, this is a presentation problem. MySQL will
store the number as digits only (unless you are storing in a character
field - but why would you?). If using PHP, for instance, the output of
the field would be
number_format($fieldvalue)
or if you want the answer to two decimal places
number_format($fieldvalue, 2)
Regards
Terry
http://booksihaveread.awardspace.co.uk----- Original Message -----
> *From:* coolcoder <
bless1_4u@...>
> *To:*
mysql@...
> *Date:* Thu, 23 Aug 2007 03:55:27 -0700 (PDT)
>
> Was wondering if anyone could help me with this little problem I'm
> having.
> I'd like to have a comma separator after every 3 digits. E.g
> "3,000,000".
> How would i go about this?
>
>
>
>
>
>
> www.coderewind.com
> Best Place to hunt for Code
> --
> View this message in context:
>
http://www.nabble.com/seoparator-help-tf4316769.html#a12291343> Sent from the MySQL - General mailing list archive at Nabble.com.
>
--
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.484 / Virus Database: 269.12.2/967 - Release Date: 22/08/2007 18:51
--
MySQL General Mailing List
For list archives:
http://lists.mysql.com/mysqlTo unsubscribe:
http://lists.mysql.com/mysql?unsub=lists@...
