decimal places is mysql

Post here if you need help with SQL.
Post Reply
jonathon
Posts: 50
Joined: Fri May 06, 2011 5:09 pm

decimal places is mysql

Post by jonathon »

Hello

I'm inserting some data from a CSV and loading the file through MYSQL. Which works fine, but i have some longitude and latitude values with 5 decimal places, but every time I insert the file, the decimal places get stripped to 2 decimal places. I've been through my CSV and formatted all the decimal places to 5 and i specified the columns as both float (7,2) and decimal (7,2) and neither of them have worked. Am I missin g something :S

Thanks in advance
bowersbros
Posts: 534
Joined: Thu May 05, 2011 8:19 pm

Re: decimal places is mysql

Post by bowersbros »

try float(7,5)
I don't like to brag, but I wasn't circumcised. I was circumnavigated. ;)

Want to learn something new? Or maybe reinforce what you already know? Or just help out? Please subscribe to my videos: http://goo.gl/58pN9
jonathon
Posts: 50
Joined: Fri May 06, 2011 5:09 pm

Re: decimal places is mysql

Post by jonathon »

How silly :oops:

Thanks :)
Post Reply