Closed wudimeicom closed 2 years ago
create table villages_64 as select from villages where provinceCode='64'; ALTER TABLE villages_64 ADD PRIMARY KEY( code); create table villages_65 as select from villages where provinceCode='65'; ALTER TABLE villages_65 ADD PRIMARY KEY( code);
villages_64
code
villages_65
可以根据具体需求自定义即可
modood
commented
2 years ago
create table villages_64 as select from villages where provinceCode='64'; ALTER TABLE
villages_64ADD PRIMARY KEY(code); create table villages_65 as select from villages where provinceCode='65'; ALTER TABLEvillages_65ADD PRIMARY KEY(code);