GeoNames Forum

Hi!

I am sure, there are question like this, I just not found it.

I'd like to create a table with only Capitols, cities and villages.

I tried this:

Code:

INSERT INTO cities (`name`, `asciiname`, `alternateNames`, `lat`, `lng`, `country`, `elevation`, `timezone`) SELECT `name`, `asciiname`, `alternatenames`, `latitude`, `longitude`, `country`, `elevation`, `timezone`  FROM `geoname` AND `fcode` = 'PPL'

The problem is, for Hungary it gives me back 9000+ records, while this country has about 3200+ cities, villages.

I've tried PPLS but for that there are no entrie for Hungary.

How can I get this list for all countries?