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
decimal places is mysql
-
- Posts: 534
- Joined: Thu May 05, 2011 8:19 pm
Re: decimal places is mysql
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
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
Re: decimal places is mysql
How silly
Thanks
Thanks