美国城市和州的列表/数据库 [英] List/Database of U.S cities and states

问题描述

我想要一个.csv列表，mysql数据库或所有美国州和城市的任何其他列表，包括哪些城市在哪个状态。从这个列表，我将生成一个mysql数据库与以下字段：

I want a .csv list, mysql database, or any other list of all U.S states and cities, including which cities are in which state. From this list I will generate a mysql database with the following fields:

states:
 - id (int, auto_increment, primary)
 - name (varchar 255)

cities:
 - id (int, auto_increment, primary)
 - stateId (id of the state from states table to which this city belongs)
 - name (varchar 255)

/ p>

Thanks in advance.

推荐答案

查看 MySQL世界示例数据库。

它已经有一个'cities'表你正在寻找。

It already have a 'cities' table you are looking for.

这篇关于美国城市和州的列表/数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！