Çë½ÌsqliteÊý¾Ý¿âÖÐÎÄÂÒÂëµÄÎÊÌâ
¿ª·¢ÓïÑÔ£ºevc Êý¾Ý¿â£ºSQLite ˵Ã÷£ºÓÐÁ½¸ö½çÃæ ½çÃæÒ»¸öÊÇÓÃÀ´½¨Á¢Êý¾Ý¿â£¬²¢ÇÒ½øÐÐÊý¾Ý¹ÜÀí¹¦ÄÜ£¬°üÀ¨ctrlist¿Ø¼þÏÔʾÊý¾Ý¿âÄÚÈÝ£¬Ôö¼Ó£¬É¾³ý£¬Ð޸ĵȹ¦ÄÜ£» ½çÃæ¶þ£¬Êǵ÷ÓÃÊý¾Ý¿â£¬½øÐвéѯ£¬ÏÔʾ½á¹ûÏÔʾÔÚEDIT¿Ø¼þÖС£ 1£©ÔÚÄ£ÄâÆ÷ÖУ¬´´½¨Êý¾Ý¿â£¬½øÐвåÈëÊý¾Ý£¬¿ÉÒÔÔÚctrlist¿Ø¼þÖÐÕý³£ÏÔʾ£¬Ìí¼Ó£¬É¾³ý£¬¶¼¿ÉÒÔʹÓ㬵«ÊǽçÃæ¶þµÄ³ÌÐòʹÓÃÊý¾Ý¿âµÄʱºò£¬²»Äܳɹ¦£¬ÎÒÊÇʹÓÃSQLite Expert Personal´ò¿ª½¨Á¢µÄÊý¾Ý¿âµÄʱºò£¬·¢ÏÖÊý¾Ý¿â¶¼ÊÇÂÒÂ룬¡£ 2£©Èç¹ûʹÓÃSQLite Expert Personal½¨Á¢Êý¾Ý¿â£¬½çÃæ¶þµÄ³ÌÐò¿ÉÒÔÕýȷʹÓÃÊý¾Ý¿â£¬µ«ÊÇÔÚ½çÃæÒ»ctrlistÖУ¬ÏÔʾÂÒÂ룬ÎÞ·¨¶ÔÊý¾Ý½øÐÐÐ޸ġ¢É¾³ý¡¢Ìí¼ÓµÈ²Ù×÷¡£ Çë½Ì£¬Õâ¸öÎÊÌâÔõÑù½â¾öÄØ£¿
ÓÐһЩ½øÕ¹£¬ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éѯÊý¾Ý¿â£¬ÏÔʾ¿Ø¼þÉÏ£¬³öÏÖÁËÖÐÎÄÂÒÂëµÄÎÊÌ⣬¼ÌÐøÇë½Ì¡«ÒýÓà list control ¿Ø¼þ ÖйÀ¼ÆÐèÒª´¦ÀíÒ»ÏÂ×Ö·û¼¯¡£ SQLiteÖеĺº×ÖÐèÒªÓÃUTF×Ö·û¼¯¡£ ÇëÎÊÒªÔõÑù´¦ÀíÄØ £¿ÕâÁ½ÌìÒ»Ö±Ôڲ飬ûÓÐÕÒµ½ºÃµÄ½â¾ö°ì·¨ÒýÓà list control ¿Ø¼þ ÖйÀ¼ÆÐèÒª´¦ÀíÒ»ÏÂ×Ö·û¼¯¡£ SQLiteÖеĺº×ÖÐèÒªÓÃUTF×Ö·û¼¯¡£ list control ÓÃʲô×Ö·û¼¯ÄØ£¿ÒýÓà list control ¿Ø¼þ ÖйÀ¼ÆÐèÒª´¦ÀíÒ»ÏÂ×Ö·û¼¯¡£ SQLiteÖеĺº×ÖÐèÒªÓÃUTF×Ö·û¼¯¡£ ÎÒÈ·¶¨ÁË´íÎóµÄµØ·½£¬¾ÍÊÇÔÚ¶ÁÊý¾Ý¿âÊý¾Ý£¨UTF-8£©ÏÔʾÔÚlist control¿Ø¼þÊÇ£¬
Ïà¹ØÎÊ´ð£º
ÎÒÒª°ÑÊý¾Ý±íÖеÄÊý¾Ý£¬ÒÔÊ÷µÄÐÎʽÏÔʾÔÚ¶Ô»°¿òÖС£ ±ÈÈ磺 Ö»ÒªÊý¾Ý±íÖÐÓÐ3¸ö×ֶΡ¢id¡¢parentid¡¢name ÇëÎÊÎÒÈçºÎдһЩ´úÂ뽫Êý¾Ý±íÖеÄÄÚÈÝÌîµ½Ê÷¿Ø¼þÖÐÈ¥ ÒýÓà һ°ãÊÇÓõݹéµÄ·½·¨À´ÊµÏ ......
¸ÕÈëÃÅ ÏëʵÏÖÐÂÎűíÐÂÎÅÖö¥µÄ¹¦ÄÜ select * from web_news order by id desc limit 0,6 web_news ±íÀïÓÐTOPÁÐ ÔõÑùÈÃTOPÁмǼΪ1µÄΪÖÃǰ ¸÷λ´ó´óÃǰï°ïæ ·Ö²»¶à Çë°üº£¡£¡ order ......
sqlite ÖÐ CREATE TABLE table1 ( id integer primary key autoincrement, name text default '', [index] integer default ROWID ) ÓÐûÓÐÀàËÆµÄ¹¦ÄÜ£¬Èà index µÄֵĬÈϵÈÓÚid£¬ ......
´ó¼ÒºÃ, ÉÏÀñ°ÝÓÐÀ´ÎÊ˵ÈçºÎ´ÓlinuxÉÏ·ÖÏí³ösqliteµÄdbÊý¾ÝÈÃwindows²Ù×÷, ºóÀ´Ò»Ö±ÎÞ·¨Ö±½Ó͸¹ýip·½Ê½Äõ½µµ°¸, Ïë˵¸ÄÓÃftp·½Ê½¶ÁµµÐ´Èëºó, ÔÙÉÏ´«»Ølinux server, ÏÖÔÚÓиöÎÊÌâµ±win pc¿ªÆôdbµµ°¸ºó, ºÃÏñ»áËø×¡Ë ......
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 IN ......