Of Countries and their Cities

database countries
Harsha M V picture Harsha M V · Oct 2, 2010 · Viewed 193k times · Source

I need a database of Countries and their Cities.

Any idea where I can get such a list?

Answer

pyfunc picture pyfunc · Oct 2, 2010

There are quite a few available.

The following has database for 2,401,039 cities

http://www.geodatasource.com/world-cities-database/free

Related questions

An open source SQL database for the list of towns cities by country?

I am looking for a list of towns, cities by country (the countries I mean here are all countries that exist on planet Earth). Is there any open-source SQL database available online which I can download and use, or any …

Read More
Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More