解决方案 »
- 将Mysql Connector/net6.4.4升级为6.5.4后出错,在线等,各位大哥帮帮忙
- mysql在Win7下写入速度慢怎么解决
- Mysql的CPU经常超过50%,算不算正常?
- MySQL服务器最近老是出现很多Locked进程
- 用户和客户表,如果得到所有的客户数少于3个的用户?
- sql语句:如何查询某列数值(int)按照数值的大小来排列?
- mysql的查询问题,有关select .... where ..in ()的
- 请教mysql executeBatch 越来越慢的问题
- 请进!!!!mysql && hp-ux
- mysql win编译
- 啥叫 an (automatic) purge operation 呢?
- MYSQL数据库定时清理备份怎么写
select * from b b1 where not exists(select 1 from b where b1.barcode=barcode and
date(`date`)='2011-04-07')) c on a.barcode=c.barcode
from 表A
where barcode not in (select barcode from 表B where date(`date`)='2011-04-07')
select * from a a1 join b b1 on a.id=b.id
where not exists(select 1 from b x where x.id=b1.id and x.`date`>b1.`date`)