stephenjtong
/ 中国省市地区SQL.sql
Last active
February 26, 2022 05:06
中国省市地区SQL（来源：互联网） http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2013/index.html
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| | |
| -- | |
| -- 表的结构 `area` | |
| -- | |
| DROP TABLE IF EXISTS `area`; | |
| CREATE TABLE IF NOT EXISTS `area` ( | |
| `id` int(11) NOT NULL auto_increment, | |
| `areaID` int(11) NOT NULL, | |
| `area` varchar(20) character set gbk NOT NULL, |