Problem with LOAD DATA in INTEGER values

Auto-rounding fields with numbers

[jspeed]

I am somewhat of a novice with mysql, so this may be easily figured out. I haven't been able to find anything searching.

Im creating a db using the load data from a CSV. Everything works fine, except, anything I have as in Integer, it automatically rounds it.

e.g.

12.12592758890 is now 12

or

75360.96738860000 is now 75361

I need these numbers to be exactly as they are in the CSV. I've tried using different field values such as BIGINT, DEC, etc with no luck. What am I missing?

[whoisgregg]

You'll definitely need your column set up as either a FLOAT or a DECIMAL type.

[jspeed]

Thank you, FLOAT is what I needed. I looked right past it on the MySQL site.