ÔÚÏßµÈ,¹ØÓÚmysqlÓï¾äתsqliteÓï¾äµÄÎÊÌâ

SQL code:
SELECT a1.FileID AS FileID, SUM( a1.Count + a2.Count + a3.Count + a4.Count ) AS Count
from gmpTableWordList AS a1
INNER JOIN gmpTableWordList AS a2
INNER JOIN gmpTableWordList AS a3
INNER JOIN gmpTableWordList AS a4 ON a1.FileID = a2.FileID
AND a2.FileID = a3.FileID
AND a3.FileID = a4.FileID
AND a1.Word = "Tempest"
AND a2.Word = "EMC"
AND a3.Word = "shielding"
AND a4.Word = "glass"
GROUP BY FileID
ORDER BY Count DESC
LIMIT 0 , 30


ÕâÔÚMYSQLÏÂÄÜ˳ÀûÖ´ÐУ¬µ«ÔÚSQLiteϲ»ÐУ¬ËÑË÷ÁËÒ»ÏÂÏà¹ØÎĵµ£¬Ó¦¸ÃÊÇsqlite²»Ö§³ÖÕâÖÖ²éѯ·½Ê½¡£Çë¸ßÊÖ°ï°ï棬°ÑÒÔÉÏ´úÂëת³ÉsqliteÄÜÖ´ÐеÄÓï¾ä£¬ÆäÖÐa1,a2,a3.....µÄ¶àÉÙÊǸú¾ÝWordµÄ¶àÉÙÀ´¾ö¶¨µÄ£¬Ä¿Ç°Ö»ÊÇTempest,EMC,shielding,glass.ллÁË£¡ÔÚÏßµÈ.

---

Ó¦¸ÃÖ§³Ö°¡¡£ÄãµÄ±í gmpTableWordList µÄ½¨±íÓï¾äÊÇʲô£¿Ìù³öÀ´´ó¼Ò¿ÉÒÔ²âÊÔһϡ£

---

Ìáʾʲô

---

ÒýÓÃ

Ó¦¸ÃÖ§³Ö°¡¡£ÄãµÄ±í gmpTableWordList µÄ½¨±íÓï¾äÊÇʲô£¿Ìù³öÀ´´ó¼Ò¿ÉÒÔ²âÊÔһϡ£

½¨±íÓï¾äÊÇÕâ¸ö£º
SQL code:
CREATE TABLE gmpTableWordList (Word varchar(50) NOT NULL, FileID int(10) NOT NULL, Count INTEGER UNSIGNED)") or die("´´½¨±íʧ°Ü£¡");

---

ÌáʾʲôÐÅÏ¢£¿SQLIT3Ö§³ÖLIMIT

---

ÒýÓÃ