SQL statements linked by province, city, and county levels

No CREATETABLE 't_ address_province '('id' INTAUTO _ INCREMENTPRIMARYKEYCOMMENT primary key, 'code' CHAR (6) NOTNULLCOMMENT provincial code, 'name' VARCHAR (40) NOTNULLCOMMENT province name) ENGINEInnoDBDEFAULTCHARSETUTF8C

No create table 't_ address_province '('id' INT AUTO_INCREMENT primary key comment 'Primary key', 'code' CHAR (6) not null comment 'province Code', 'name' VARCHAR (40) not null comment' province name') ENGINE = InnoDB default charset = UTF8 C

SQL statements linked by province, city, and county levels <无>

Create table 't_ address_province '('id' INT AUTO_INCREMENT primary key comment 'Primary key', 'code' CHAR (6) not null comment 'province Code ', 'name' VARCHAR (40) not null comment' province name') ENGINE = InnoDB default charset = UTF8 COMMENT = 'province info table '; create table 't_ address_city '('id' INT AUTO_INCREMENT primary key comment 'Primary key', 'code' CHAR (6) not null comment 'city Code ', 'name' VARCHAR (40) not null comment 'city name', 'vincecode' CHAR (6) not null comment' province Code ') ENGINE = InnoDB default charset = UTF8 COMMENT = 'city info TABLE '; create table 't_ address_town' ('id' INT AUTO_INCREMENT primary key comment 'Primary key ', 'code' CHAR (6) not null comment 'area/county Code', 'name' VARCHAR (40) not null comment 'area/county name', 'citycode' CHAR (6) not null comment 'city Code') ENGINE = InnoDB default charset = UTF8 COMMENT = 'District/county info table ';