List:General Discussion« Previous MessageNext Message »
From:Simon Griffiths Date:February 12 2012 4:26pm
Subject:RE: Formatting Numbers with commas
View as plain text  
Please see 

http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_format

Regards,

Simon Griffiths

-----Original Message-----
From: Mike Blezien [mailto:mickalo@stripped] 
Sent: 12 February 2012 16:00
To: MySQL List
Subject: Formatting Numbers with commas

Hello,

Is there a function to automatically format long numercial values before
it's entered into the table, i.e I have a value like 159600 and would be
entered as
159,600 or 78450 would be entered 78,450 etc., ?

Thank you,
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming & Web Hosting Services
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Thread
Formatting Numbers with commasMike Blezien12 Feb
  • RE: Formatting Numbers with commasSimon Griffiths12 Feb
  • Re: Formatting Numbers with commasMike Blezien12 Feb
  • Re: Formatting Numbers with commasReindl Harald12 Feb