您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

根据二度人脉推荐好友sql

2024/2/26 17:49:57发布8次查看
friend表结构 drop table if exists friend; create table friend( uid bigint not null comment '用户标识', friend_uid bigint not null comment '申请加为好友的用户标识', sys_create_date datetime not null comment '申请时间', sys_last_update datet
friend表结构
drop table if exists friend;
create table friend(
uid bigint not null comment '用户标识',
friend_uid bigint not null comment '申请加为好友的用户标识',
sys_create_date datetime not null comment '申请时间',
sys_last_update datetime not null comment '更新时间',
state tinyint not null comment '好友状态 0 : 删除, 1:申请好友, 2 : 好友',
primary key(uid, friend_uid)
)engine=innodb default charset=utf8 comment '好友表';
select friend_uid from
friend where state=2 and
uid in (select friend_uid from friend where uid=13 and state=2)
and friend_uid not in (select friend_uid from friend where uid=13 ) and friend_uid != 13 limit 6
uid为当前用户的id,为id为13的用户查询二度人脉好友
该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product