Chinese city coordinate SQL code

China city coordinate SQL code MySQLCREATETABLE 'test _ data' ('id' varchar (50) NOTNULLdefault, 'province 'varchar (100) NOTNULLCOMMENT provincial level, 'city' varchar (100) NOTNULLCOMMENT city, 'county 'varchar (100) NOTNULL, 'longyun' varchar (20)

China city coordinate SQL code MySQL CREATE TABLE 'test _ data' ('id' varchar (50) NOT NULL default '', 'province 'varchar (100) not null comment 'provincial level ', 'city' varchar (100) not null comment 'city', 'county' varchar (100) not null, 'longance' varchar (20)

China city coordinate SQL code MySQL

Create table 'test _ data' ('id' varchar (50) not null default '', 'category' varchar (100) not null comment' provincial level ', 'city' varchar (100) not null comment 'city', 'county 'varchar (100) not null, 'longning' varchar (20) not null, 'latitude 'varchar (20) not null, primary key ('id') ENGINE = InnoDB default charset = utf8; Download Attachment for specific code