List:General Discussion« Previous MessageNext Message »
From:Mike Blezien Date:February 12 2012 4:39pm
Subject:Re: Formatting Numbers with commas
View as plain text  
Thank you Simon exactly what I was looking for. Appreciate the assistance.


Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming & Web Hosting Services
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  ----- Original Message ----- 
  From: Simon Griffiths 
  To: 'Mike Blezien' ; 'MySQL List' 
  Sent: Sunday, February 12, 2012 10:26 AM
  Subject: RE: Formatting Numbers with commas


  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