At 10:17 -0700 5/14/04, David Blomstrom wrote:
--- Joshua Beall <[EMAIL PROTECTED]> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]