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

Çë½Ì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¿Ø¼þÊÇ£¬


Ïà¹ØÎÊ´ð£º

Çë½Ì£ºVCÖеÄTree¿Ø¼þÓëSQLiteÊý¾Ý±íµÄʹÓÃÎÊÌâ

ÎÒÒª°ÑÊý¾Ý±íÖеÄÊý¾Ý£¬ÒÔÊ÷µÄÐÎʽÏÔʾÔÚ¶Ô»°¿òÖС£
±ÈÈ磺
Ö»ÒªÊý¾Ý±íÖÐÓÐ3¸ö×ֶΡ¢id¡¢parentid¡¢name
ÇëÎÊÎÒÈçºÎдһЩ´úÂ뽫Êý¾Ý±íÖеÄÄÚÈÝÌîµ½Ê÷¿Ø¼þÖÐÈ¥ 

ÒýÓÃ
Ò»°ãÊÇÓõݹéµÄ·½·¨À´ÊµÏ ......

sqliteÊý¾Ý¿â²éѯ±í¿¿Ç°

¸ÕÈëÃÅ ÏëʵÏÖÐÂÎűíÐÂÎÅÖö¥µÄ¹¦ÄÜ

select * from web_news  order by id desc limit 0,6

web_news ±íÀïÓÐTOPÁÐ ÔõÑùÈÃTOPÁмǼΪ1µÄΪÖÃǰ  ¸÷λ´ó´óÃǰï°ïæ ·Ö²»¶à Çë°üº­£¡£¡
order ......

sqlite ×Ö¶ÎĬÈÏÖµµÈÓÚidÖµ

sqlite ÖÐ
CREATE TABLE table1 (
id integer primary key autoincrement,
name text default '',
[index] integer default ROWID
)

ÓÐûÓÐÀàËÆµÄ¹¦ÄÜ£¬Èà index µÄֵĬÈϵÈÓÚid£¬ ......

windowsץȡlinuxÉÏsqlite db問題

´ó¼ÒºÃ, ÉÏÀñ°ÝÓÐÀ´ÎÊ˵ÈçºÎ´ÓlinuxÉÏ·ÖÏí³ösqliteµÄdbÊý¾ÝÈÃwindows²Ù×÷, ºóÀ´Ò»Ö±ÎÞ·¨Ö±½Ó͸¹ýip·½Ê½Äõ½µµ°¸, Ïë˵¸ÄÓÃftp·½Ê½¶ÁµµÐ´Èëºó, ÔÙÉÏ´«»Ølinux server, ÏÖÔÚÓиöÎÊÌâµ±win pc¿ªÆôdbµµ°¸ºó, ºÃÏñ»áËø×¡Ë ......

ÔÚÏßµÈ,¹ØÓÚ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
IN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ