MYSQL两个表关联查询_MySQL
来源:懂视网
责编:小采
时间:2020-11-09 19:34:06
MYSQL两个表关联查询_MySQL
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
导读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
SELECT
states.state_id,
states.state_name,
cities.city_id,
cities.city_name,
cities.region_id
FROM states
INNER JOIN cities
ON states.state_id=cities.state_id
WHERE states.countrycode=”counttrycode“;
也可以使用别名:
如下:
SELECT
s.state_id,
s.state_name,
c.city_id,
c.city_name,
c.region_id
FROM states s
INNER JOIN cities c
ON s.state_id=c.state_id
WHERE s.countrycode=”counttrycode“;
s 是states的别名, c是cities的别名。这样当名字很长时比较好用。
声明:本网页内容旨在传播知识,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
MYSQL两个表关联查询_MySQL
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