insert into outbox(userId, feedId, create_time) values("A", $feedId, $current_time); //写入A的发件箱
insert into inbox(userId, feedId, create_time) values("B", $feedId, $current_time); //写入B的收件箱
insert into inbox(userId, feedId, create_time) values("C", $feedId, $current_time); //写入C的收件箱
insert into inbox(userId, feedId, create_time) values("D", $feedId, $current_time); //写入D的收件箱
select feedId from inbox where userId = "B";
insert into outbox(userId, feedId, create_time) values("B", $feedId, $current_time); //写入B的发件箱
select feedId from outbox where userId in (select userId from follower where fanId = "A") order by create_time desc
10 人点赞
10