Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔÚÏßµÈ,¹ØÓÚ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

ÒýÓÃ


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ