Dump USA Basic Cities on MySql Database

• Project ID:

  632044

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

Hi,

I offer $25 for this small work.
(mysql file with all content is attached here)

I have 3 RELATED tables on mysql database:
City
Country
State

The State Table already contains all USA states, and Country table already Contains the only country I need: USA.

So, the missig part is the CITIES content. And that is what I need you to do, to DUMP all BASIC USA CITIES. Of course every city should be related to its state on the state table.

IMPORTANT: I DONT WANT ALL USA CITIES, there are around 19,355 cities, I just want the BASIC/MAIN cities for every State.

Please Make sure to know what I want before bidding, Notice that I will not accept the dump with ALL USA Cities (I already have this table) I just want the BASIC/Main USA Cities for every state. Also mention my name on your PM so I know you have read my message and not just copy/paste your text.

thanks
Fer.

Skills required:

CMS, Microsoft Access, MySQL, PHP, SQL

Additional Files:

CitiesSql.sql