Node/Koa2[07]: 连表查询
·
Yin灏
# 连表查询
select * from blogs inner join users on users.id = blogs.userid;
# 查询 blogs 所有信息，并且 users 表的局部信息（排除id）
select blogs.*, users.username, users.nickname from blogs inner join users on users.id = blogs.userid;
# 添加查询条件
select blogs.*, users.username, users.nickname from blogs inner join users on users.id = blogs.userid where users.username='lisi';