--省级 provincial create table provincial ( provincialID int, provincialName varchar(50), primary key (provincialID) )engine=INNODB default charset=gbk; insert into provincial values(1,'北京市'); insert into provincial values(2,'天津市'); insert into provincial values(3,'上海市'); insert into provincial values(4,'重庆市'); insert into provincial values(5,'河北省'); insert into provincial values(6,'山西省'); insert into provincial values(7,'台湾省'); insert into provincial val......
阅读全文