GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Import txt on mysql  XML
Forum Index -> General
Author Message
blackbeen



Joined: 20/05/2018 11:20:15
Messages: 2
Offline

Hello, I have the FR.zip file I would like to know how to import it into a database on mysql
danielmod



Joined: 09/08/2018 03:03:04
Messages: 1
Offline

Maybe it's can solve your problem,

Code:
LOAD DATA INFILE '/tmp/xx.txt' INTO TABLE PerformanceReport;
 
 LOAD DATA LOCAL INFILE '/tmp/xx.txt' 
 INTO TABLE foo COLUMNS TERMINATED BY '\t';

It's my best KDL Sniper e-book.
[WWW]
finnich



Joined: 15/08/2018 09:04:13
Messages: 1
Location: Alabama
Offline

Yes, the above code works properly!
[WWW]
juanjo32



Joined: 20/08/2018 13:40:22
Messages: 1
Location: Barcelona, Spain
Offline

Thank you, you've helped me a lot.
[WWW]
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team