|
找出有重複資料的內容
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"
|