全国省市区的sql语句
CREATE TABLE city (
id int(11) NOT NULL DEFAULT '0',
pid int(11) DEFAULT NULL,
cityname varchar(255) CHARACTER SET utf8 DEFAULT NULL,
type int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of city
-- ----------------------------
INSERT INTO city VALUES ('1', '0', '中国', '0');
