Help With MYSQL And Decimal Points

[golfinggod]

HI All
Just wanted to know how I would go about inserting the values 0.02 0.05 0.06 into a mysql table. Ive tried setting the table columns to decimal and Float but the problem is that mysql always rounds the numbers of to the nearest whole number

i.e. 0.06 gets rounded to 1 instead of staying at 0.06

Cheers All

p.s As well as setting to decimal and float do i need to set any other settings ie. default or Value

[chyan]

use "double" as your type data

[chyan]

DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL]
A normal-size (double-precision) floating-point number. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308. If UNSIGNED is specified, negative values are disallowed. The M is the display width and D is the number of decimals. DOUBLE without arguments or FLOAT(X) where 25 <= X <= 53 stands for a double-precision floating-point number.

[golfinggod]

Cheers
😃

[sy-co]

It possible you didnt set the decimal you'll need to for whatever type ypu use.

heres the mysql.com man ref on float

FLOAT[(M,D)] [UNSIGNED] [ZEROFILL]
A small (single-precision) floating-point number. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38. If UNSIGNED is specified, negative values are disallowed. M is the display width and D is the number of decimals. FLOAT without arguments or FLOAT(p) (where p is in the range from 0 to 24) stands for a single-precision floating-point number.

Here's the entry for double

DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL]
A normal-size (double-precision) floating-point number. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308. If UNSIGNED is specified, negative values are disallowed. M is the display width and D is the number of decimals. DOUBLE without arguments or FLOAT(p) (where p is in the range from 25 to 53) stands for a double-precision floating-point number.

[sy-co]

damm too quick for me!

😃