专题文章
时长:00:00更新时间:2020-11-09 19:34:06
MYSQL两个表关联查询_MySQL:SELECTstates.state_id,states.state_name,cities.city_id,cities.city_name,cities.region_idFROM statesINNER JOIN citiesON states.state_id=cities.state_idWHERE states.countrycode=counttrycode;也可以使用别名:如下:SELECTs.state_id,s.state_name,c.city_id
查看详情