You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
// 排除正确的市级地名sqlite> select city.name, province.name from city \ left join province \ where city.name not like "%市%" \ and city.name not like "%自治州%" \ and city.name not like "%地区%" \ and city.name not like "%盟%" \ and city.provinceCode = province.code; 省直辖县级行政区划|河南省省直辖县级行政区划|湖北省省直辖县级行政区划|海南省县|重庆市自治区直辖县级行政区划|新疆维吾尔自治区
现象
可以看到数据有多余。
Reference
PS. 借机感谢分享的劳动成果!
The text was updated successfully, but these errors were encountered: