hwo to i store decimal value in database?

[sid0972]

i already have the particular column as float, and input is of the form 9999.999

 

i dont think if number_format's going to be of much help here.

What should i use??

[sid0972]

silly me

 

varchar() works fine.

thanks for looking though

[Barand]

DECIMAL(8,3)

[sid0972]

can i have an example please?

[kicken]

Just define the column as a DECIMAL(8,3) type and then insert the number.

 

CREATE TABLE blah (
   num DECIMAL(8,3) 
);

INSERT INTO blah (num) VALUES (9999.999)

 

[Barand]

  On 2/10/2013 at 9:29 PM, sid0972 said:

can i have an example please?

 

I just did

  On 2/10/2013 at 7:26 PM, Barand said:

DECIMAL(8,3)

 

OK Here's the served-up-on-a-plate answer

 

Instead of VARCHAR(xx) use DECIMAL(8,3)

[sid0972]

  On 2/10/2013 at 9:33 PM, Barand said:

I just did

 

 

OK Here's the served-up-on-a-plate answer

 

Instead of VARCHAR(xx) use DECIMAL(8,3)

 

i thought it was a function of php

but kicken cleared it well and good.