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. ![Wink ;)](./images/smilies/icon_e_wink.gif)
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
![Wink ;)](./images/smilies/icon_e_wink.gif)
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![Smile :)](./images/smilies/icon_e_smile.gif)
![Embarrassed :oops:](./images/smilies/icon_redface.gif)
Thanks
![Smile :)](./images/smilies/icon_e_smile.gif)