List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 14 2004 5:26pm
Subject:Re: Integers - How would you enter 112,249?
View as plain text  
At 10:17 -0700 5/14/04, David Blomstrom wrote:
>--- Joshua Beall <jbeall@stripped> wrote:
>
>>  AFAIK 112,249 is not an integer.  It is a string.
>>  If you need to have the
>>  commas, you need to store it as a string.
>
>I haven't got to strings yet. The table I'm making is
>for display purposes, so I want visitors to be able to
>see 10,212, rather than 10212. I'm also going to make
>JavaScript sortable columns.
>
>So do I need to store it as a string if I want to
>display columns? Or would I simply use some other
>function to insert commas for display purposes?

Insertion and display are two different issues.
To insert a number, no commas are allowed.
To display a number with commas, you can use the
FORMAT() function:

http://dev.mysql.com/doc/mysql/en/Miscellaneous_functions.html

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Thread
Integers - How would you enter 112,249?David Blomstrom14 May
  • Re: Integers - How would you enter 112,249?Dan Nelson14 May
  • Re: Integers - How would you enter 112,249?Paul DuBois14 May
Re: Integers - How would you enter 112,249?Joshua Beall14 May
  • Re: Integers - How would you enter 112,249?David Blomstrom14 May
    • Re: Integers - How would you enter 112,249?Paul DuBois14 May
Re: Integers - How would you enter 112,249?SGreen14 May