日期:2014-05-17 浏览次数:20828 次
DROP TABLE IF EXISTS `txt_base`;
CREATE TABLE `txt_base` (
`Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`f_id` int(11) DEFAULT NULL COMMENT '关联ID',
`lan_id` int(11) DEFAULT NULL COMMENT '语言ID',
`txt` varchar(255) DEFAULT NULL COMMENT '文本内容',
`desc` varchar(255) DEFAULT NULL COMMENT '备注描述',
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
INSERT INTO `txt_base` VALUES (1,1,1,'苹果','中文');
INSERT INTO `txt_base` VALUES (2,1,2,'apple','英文');
INSERT INTO `txt_base` VALUES (3,1,3,'pingguo','日文');
INSERT INTO `txt_base` VALUES (4,4,1,'橘子','中文');
INSERT INTO `txt_base` VALUES (5,4,2,'orange','英文');
INSERT INTO `txt_base` VALUES (6,6,1,'香蕉','中文');
/*!40000 ALTER TABLE `txt_base` ENABLE KEYS */;
UNLOCK TABLES;
select *
from txt_base a
where a.f_f_id not in
(select distinct b.f_f_id from txt_base b where b.f_lan_id = 2);
select *
from txt_base a
where a.f_f_id not in
(select distinct b.f_f_id from txt_base b where b.f_lan_id in (3));