| 老妖怪的二三事 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/ |
|