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
