MySQL数据库三
- 多表查询:
- 有条件的内连接
-
将两张表根据相同的id连接起来
- select * from info join details on info.id = details.id
-
select info.id,phonenum from info join details on info.id = details.id;
MySQL数据库三
将两张表根据相同的id连接起来
select info.id,phonenum from info join details on info.id = details.id;