GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
How do I upload only 2 txt files to SQL?  XML
Forum Index -> FAQ - frequently asked questions
Author Message
letsforum



Joined: 25/09/2016 11:05:32
Messages: 4
Offline

Guys I am on a shared hosting ain't have full access to all SQL features.

I am only interested in 2 files ES, AR. I only want the cities and county names nothing else.

Please help me to create table for that and upload all that stuff and make it work.

P.S is there a way to let say retrieve this data.

City or town -> it's province or state it belong to?
cale


[Avatar]
Joined: 26/09/2017 08:49:01
Messages: 2
Offline

it's a bit late for me to answer this one but i still want to answer.


Guys I am on a shared hosting ain't have full access to all SQL features.  


I assume you can access the database where you can at least create/edit table.


I am only interested in 2 files ES, AR. I only want the cities and county names nothing else.
 


Upload them all.
Then go to STRUCTURE, delete the unnecessary column, don't delete the primary index ID column because it is better to have an index.



P.S is there a way to let say retrieve this data.

City or town -> it's province or state it belong to? 


Code:
 SELECT * FROM table WHERE city='cityName'
 
 or
 
 SELECT * FROM table WHERE state='stateName'
 
Forum Index -> FAQ - frequently asked questions
Go to:   
Powered by JForum 2.1.5 © JForum Team