March 17th, 2013, 09:18 PM
-
Data Import to mysql 5.5
I have a file that contains Latitude and Longitude and would like to import it into mysql and the correct fields lat = latitude lon = longitude is this possible? and can someone help with the correct query to load the file is /home/user/out.txt
the format is like this:
Latitude:39.00
Longitude:-86.00
Latitude:38.00
Longitude:-82.00
Latitude:33.00
Longitude:-84.00
March 17th, 2013, 10:48 PM
-
Originally Posted by brizey
the format is like this:
you're going to have to write some application code to handle this, because importing it will yield nothing useful
what language is your preference? perl? php?
March 18th, 2013, 01:06 AM
-
php
php would be first choice perl 2nd choice
Originally Posted by r937
you're going to have to write some application code to handle this, because importing it will yield nothing useful
what language is your preference? perl? php?
March 18th, 2013, 04:50 AM
-
thx... moving thread to php forum