老妖怪的二三事
http://bbs.ainic.tw/

[MySQL] 找出有重複資料的內容
http://bbs.ainic.tw/viewtopic.php?f=25&t=296
第 1 頁 (共 1 頁)

發表人:  JoeChen [ 2009-05-28, 16:35 ]
文章主題 :  [MySQL] 找出有重複資料的內容

找出有重複資料的內容

SELECT owner, COUNT(*) AS count
FROM list
GROUP BY owner
HAVING (COUNT(*) > 1)

ex:
華碩科技 = ASUSTek COMPUTER INC.


TABLE: list & translate

INNER JOIN
(全都出來)SELECT * FROM list INNER JOIN translate ON list.owner=translate.owner
(我要的表)SELECT ouidb,zht_name FROM list INNER JOIN translate ON list.owner=translate.owner
把我要的表設成要被查尋的
$convert = (SELECT ouidb,zht_name FROM list INNER JOIN translate ON list.owner=translate.owner);
在 $convert 這個表裡, 去找符合 $nic 的那一筆, 並取出它的 zht_name



SELECT list.ouidb,translate.zht_name FROM list Left Outer JOIN translate ON list.owner=translate.owner WHERE list.ouidb="00-1F-D0"


SELECT list.ouidb,list.owner,translate.zht_name FROM list,translate INNER JOIN translate ON list.owner=translate.owner WHERE list.ouidb like "00-0D-61"
SELECT list.ouidb,list.owner,translate.zht_name FROM list left outer JOIN translate ON list.owner=translate.owner WHERE list.ouidb like "00-1F-D0"
SELECT list.ouidb,list.owner,translate.zht_name FROM list right outer JOIN translate ON list.owner=translate.owner WHERE list.ouidb like "00-1F-D0"

第 1 頁 (共 1 頁) 所有顯示的時間為 UTC + 8 小時
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/