解决方案 »
- mysql5.5怎么弄都乱码,求助!
- mysql乱码问题求助~~~
- mysql tags table
- MySql导入导出
- mysql登不上了。。。。。。。。
- 我安装mysql后,发现只能以localhost登录,不能以本机ip登录?
- 征集mysql源代码修改参与者
- mysql 的臨時表是物理表?
- phpmyadmin如何装呀,是不是必须要先安装php环境呀?
- 高分请教MySql在.net大量插入数据的问题(为什么这么慢???)
- mysql:如何把第一列和第二列一样的多行数据合并成一行?
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'test'
select crmID from modifyHistory h1
where newValue like '%已面谈%' and (modifyTime > '2012-05-01 00:00:00' and modifyTime < '2012-05-29 23:59:59')and ((select count(1) from modifyHistory h2 where newValue like '%已面谈%' and h2.crmID = h1.crmID and h2.modifyTime < h1.modifyTime) = 0)
newvalue和modifyhistory都没有建立索引..
create index x2 on modifyHistory(crmID,modifyTime);
from modifyHistory h1
where newValue like '%已面谈%'
and modifyTime between '2012-05-01' and '2012-05-29 23:59:59'
and not exists (
select 1 from modifyHistory
where newValue like '%已面谈%'
and crmID = h1.crmID
and modifyTime < h1.modifyTime
);
from modifyHistory h1
where newValue like '%已面谈%'
and modifyTime between '2012-05-01' and '2012-05-29 23:59:59'
and not exists (
select 1 from modifyHistory
where newValue like '%已面谈%'
and crmID = h1.crmID
and modifyTime < h1.modifyTime
);