MySQL表
CREATE TABLE `viewhistory` (
`viewid` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`video` varchar(255) NOT NULL,
`viewtime` datetime NOT NULL,
PRIMARY KEY (`viewid`)
)
如何查询uid=1和uid=2两个用户都观看过的视频(video)?
方法一:嵌套子查询
SELECT video from viewhistory where uid=2 and video in (SELECT video from viewhistory where uid=1)
方法二:自连接查询
SELECT a.video from viewhistory a INNER JOIN viewhistory b
on a.video=b.video where a.uid=1 and b.uid=2