Where to get SQL major cities world database?

Asked By 30 points N/A Posted on -
qa-featured

I’m currently working on an assignment which involves Education and Job Placement. I was wondering if someone knows any good SQL major cities world database to fetch data for my project. Any kind of suggestion would be appreciated.

SHARE
Best Answer by Gillam Janetj
Answered By 10 points N/A #163978

Where to get SQL major cities world database?

qa-featured

Hi Walter,

Hope you are doing good. I have a major cities database with me, which are actually insert statements. I downloaded them from http://mydatamaster.com. These fields are Auto generated ID, City Name, Country Code, District, Language, and population. I can share them with you. Please find the attachment for it.

 

Answered By 0 points N/A #163979

Where to get SQL major cities world database?

qa-featured

Hi Walter,

You can find Major Cities database at World Cities Database Website.
 
It has database listing of all cities in the world With Country Codes & States. There is around 2.3 million cities included in the database.
It has 3 tables, City table, Country Table and State Table.
 
Also you can find instruction on how to load data into MySQL.
Best Answer
Best Answer
Answered By 0 points N/A #163980

Where to get SQL major cities world database?

qa-featured

Hi. Walter Neff,

Well to get such data you have to visit someone who knows SQL or you have the second option of doing it yourself, but before that you have to study a little bit so that you eliminate any future problems in fetching your data.

You just have to install a software from the link I am providing you and can easily operate it with its help file.

I have tested it myself and its all working good. So, I will recommend it to you too.

You had to install GeoDataSource from link data

I hope that this will fix your problem.

Thanks & Regards

Gillam Janetj

 

Related Questions