56,677
社区成员
发帖
与我相关
我的任务
分享
select count(DISTINCT id) from Policyinfo p where p.filename not in
(select p2.filename from Policyreadinfo p2 where p2.reader='test')
CREATE TABLE `policyinfo` (
`id` int(11) NOT NULL auto_increment,
`filenum` varchar(50) default NULL,
`filename` varchar(100) default NULL,
`filecontent` longtext,
`writetime` datetime default NULL,
`writer` varchar(100) default NULL
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `policyreadinfo` (
`id` int(11) NOT NULL auto_increment,
`filename` varchar(500) default NULL,
`reader` varchar(100) default NULL,
`readtime` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
select count(DISTINCT p.id)
from Policyinfo p left join Policyreadinfo p2 on p.filename=p2.filename
where p2.filename is null
or p2.reader!='test'