2017-10-13T08:44:01Z||2017-10-13T08:44:01Z
逻辑关系很简单:两个表:一个user
存用户,一个user_follow
用户的关注关系。user_follow
里只有两个列,src_id
和dest_id
,也就是src_id
关注了dest_id
。现在要用SQL直接输出谁关注了谁,
MySQL:
select src.name, dest.name
from user_follow f
inner join user src on src.id = f.src_id
inner join user dest on dest.id = f.dest_id