Asked By
Walter Neff
30 points
N/A
Posted on - 09/18/2012
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.
Where to get SQL major cities world database?
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.
Where to get SQL major cities world database?
Hi Walter,
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.