#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2013
    Posts
    2
    Rep Power
    0

    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
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,209
    Rep Power
    4279
    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?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2013
    Posts
    2
    Rep Power
    0

    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?
  6. #4
  7. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,209
    Rep Power
    4279
    thx... moving thread to php forum
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo