试试是不是空格的影响:select distinct ltrim(rtrim(domain)) from access
TO: zalvsa(zalvsa)应该都是一样的,baidu.com域名哪能不一样啊,都是用程序取的select * from access where domain='baidu.com' 大概有2150条我这样试过不行select distinct trim(domain) from access
select * from table where id in(select max(id) from table group by domain)
To: Fibona(Fibona)select * from access where id in(select max(id) from access group by domain)一执行cpu就100%
汗, 照理来说不可能出现这个问题的, 要不就是mysql 出现bug了?
把查询结果var_dump();列出来比较一下
delete from access where domain = 'baidu.com'; 也会把两条记录都删除?quote: --------------------------------------------------------------------------------- To: Fibona(Fibona)select * from access where id in(select max(id) from access group by domain)一执行cpu就100% --------------------------------------------------------------------------------- 你重新装次mysql吧,可能还真是出现bug了。
哥哥我结了,你没有看到吗?
用你的第一个语句执行完后,把搜索出来的那几个baidu.com分别点修改进去看。或者复制第一个baidu.com的值,修改其他的baidu.com。
好郁闷啊
贴出结果
concat( '|' , domain , '|' )
|baidu.com|
|yahoo.com.cn|
|baidu.com|
||
|3721.com|
|china.com|
||
|ocalhost|
||
|yisou.com|
||
||
|94.161.10|
||
|365ss.cn|
|u159.sohon.com|
|yahoo.com.cn|
|online.sh.cn|
||
|tom.com|
||
|yahoo.com|
||
|3721.com|
|aocky.com|
||
|mail.163.com|
|baidu.com|
|aocky.com|
|websearch.yahoo.com|
|baidu.com|
|3721.com|
|yisou.com|
|yahoo.com.cn|
也会把两条记录都删除?quote:
---------------------------------------------------------------------------------
To: Fibona(Fibona)select * from access where id in(select max(id) from access group by domain)一执行cpu就100%
---------------------------------------------------------------------------------
你重新装次mysql吧,可能还真是出现bug了。