mysql comma issue

Hello,

I want to show show float and int values with comma in mysql database.

Like if i enter 1000 or 1000.00 it should take it as 1,000 or 1,000.00

is there any way to do this?


thank you

 

no you cannot store.

While displaying you can format t like this

Regards

Alex

 

mysql can store decimal values you can store 1000.2 or 1000.256 but you can't store 1,000. mysql will store 1000 you can then display it as 1,000 on your script.

 

what's the method to display 1000 like 1,000?

thank you
dizyn

 

This can be done with mysql FORMAT function using zero decimals.

SELECT FORMAT(1000,0);
-> '1,000'

 

how about for example

decimal( 12, 2 )

 

use number format function on php.