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

sqlite¼ÓÃÜÉè¼ÆµÄȱÏÝÓë¸Ä½ø


sqliteÊÇ
Ò»¸ö·Ç³£Ð¡ÇɵĿçƽ̨ǶÈëʽÊý¾Ý¿â£¬Ëü±¾Éí²»Ìṩ¼ÓÃܹ¦ÄÜ£¬²»¹ýÉè¼ÆÕßÃ÷ÏÔÒ²¿¼ÂÇÁ˼ÓÃܵķ½°¸£¬ÎÒÃÇÔÚÔ´ÂëÖпÉÒÔÕÒµ½Á½¸öÔ¤ÁôµÄ¼ÓÃܽÓ
¿Ú£ºsqlite3_keyºÍsqlite3_rekey£¬¿ÉÒÔͨ¹ýʵÏÖÕâÁ½¸ö½Ó¿ÚÀ´´ïµ½¼ÓÃܵÄÄ¿µÄ¡£
        ÈçºÎ¼ÓÃÜ£¬ÒѾ­ÓкܶàÎÄÕÂÃèÊö£¬¿ÉÒԲο¼:¡¶
SQLite
Êý¾Ý¿â¼ÓÃܵÄÒ»ÖÖ½â¾ö·½°¸
¡·
        ÎÒÕâÀïҪ˵µÄÊÇÕâÖÖ·½·¨µÄȱÏݺ͸ĽøµÄ·½·¨£¨²âÊÔsqlite°æ±¾v3.5.6£©£»
¼ÓÃܺ¯ÊýµÄ¼òҪ˵Ã÷£º
        sqlite3_keyµÄÊäÈë²ÎÊýÓÐÈý¸ö£ºÒ»¸öÊÇsqlite3µÄÖ¸Õ룬¶þ¡¢Èý·Ö±ðÊÇÃÜÂëµÄÖ¸ÕëºÍÊý¾Ý³¤¶È£»
        ´ÓµÚÒ»¸ö²ÎÊý£¬ÎÒÃÇ¿ÉÒÔ¿´³ö£¬±ØÐëÏÈÓÃsqlite3_open»ñÈ¡Ò»¸ösqlite3Ö¸Õ룬²ÅÄܵ÷sqlite3_keyÉèÖÃÃÜ
Ô¿£»
ÎÊÌâÃèÊö£º
       sqlite3_openµÄÄ¿µÄÊÇ´ò¿ªdatabase£¬openDatabaseµÄ¹ý³ÌÖлáÈ¥¶ÁÈ¡ºÍ½âÎödbÎļþµÄÍ·ÐÅÏ¢£»
       £¨ÎÒÃÇÓöþ½øÖƲ鿴¹¤¾ß£¨±ÈÈçUltraEdit£©´ò¿ªÊý¾Ý¿âÎļþʱ£¬»áÔÚ×îÇ°Ãæ·¢ÏÖ
“SQLite format 3...”һЩ¿É¶ÁµÄÐÅÏ¢£¬Ç°ÃæÕâ100¸ö×Ö½Ú¾ÍÊÇsqliteÊý¾ÝÎļþÍ·ÐÅÏ¢¡££©
      openDataseµÄÒ»¸öÖ÷Òª¹¦ÄܾͶÁÈ¡ÕâЩͷÐÅÏ¢£¬ÆäÖÐÓбȽÏÖØÒªµÄdatabaseµÄpage size£¬
Õâ¸ö²ÎÊýÓõÚ16¡¢17×Ö½Ú±íʾ£»ÔÚδ¼ÓÃܵÄÇé¿öÏ£¬ÎÒÃǹ۲ìÕâ¸öÖµÒ»°ãÊÇ0400£¬±íʾÊý¾Ý¿âµÄpage sizeÊÇ1024£»
      ÎÊÌâ³öÏÖÁË£ºÎÒÃÇÒѾ­ÖªµÀ£¬¼ÓÃÜÉèÖÃÊÇÔÚopenDataseÖ®ºó£¬Èç¹ûÊý¾ÝÒѾ­¼ÓÃÜ£¬opendatase±ØÈ»Äò»µ½ÕýÈ·µÄpage
sizeµÈÐÅÏ¢£¬ÄÇôΪʲô¼ÓÃܵķ½·¨Ê¹ÓÃʱûÓгö´íÄØ£¿
      ÒòΪ´ËʱÊý¾Ý¿âµÚ16¡¢17×Ö½ÚÒ»°ã»áÊÇÂÒÂ룬µ±pagesize¶Á³ö²»ÊÇ512µÄÕûÊý±¶£¬»òÕß´óÓÚij¸öֵʱ£¬opendatase»á
ĬÈÏ°Ñpage sizeµ±1024´¦Àí£¬¶øÕâÖÖ×ö·¨Ò»°ãÒ²¶¼Ã»ÓÐÎÊÌ⣨ǰÌáÊǺܶàÊý¾Ý¿âµÄ
pagesizeȷʵÊÇ1024
£©£»µ«ÕâÖÖ×ö·¨²¢²»°²È«£¬´æÔÚÁ½¸ö·çÏÕ£º
             ·çÏÕÒ»£ºÈç¹ûÊý¾Ý¿âµÄpagesize²»ÊÇ1024£¬¶øÊÇ2048£¬¼ÓÃܺóÊý¾Ý¿â»¹ÄÜ´ò¿ªÂð£¿
             ·çÏÕ¶


Ïà¹ØÎĵµ£º

QT¶ÁдSqliteÊý¾Ý¿â FurtherChan

QT¶ÁдSqliteÊý¾Ý¿â
//.h
/****************************************************************************
**
** Date    : 2010-05-08
** Author  : furtherchan
** If you have any questions , please contact me
**
****************************************************************** ......

SQLiteÓï·¨ CREATE TRIGGER


ʱ¼ä:
2009-08-14 21:18:18À´Ô´:
ÍøÂç ×÷Õß:
δ
Öª µã»÷:
214
´Î
CREATE TRIGGER
    
        
            sql-statement ::=
       ......

×ܽáSQLite²»Ö§³ÖµÄSQLÓï·¨ÓÐÄÄЩ


1 TOP
ÕâÊÇÒ»¸ö´ó¼Ò¾­³£Îʵ½µÄÎÊÌ⣬ÀýÈçÔÚSQLSERVERÖпÉÒÔʹÓÃÈçÏÂÓï¾äÀ´È¡µÃ¼Ç¼¼¯ÖеÄÇ°Ê®Ìõ¼Ç¼£º
SELECT TOP 10 * from [index] ORDER BY indexid DESC;
 
µ«ÊÇÕâÌõSQLÓï¾äÔÚSQLiteÖÐÊÇÎÞ·¨Ö´Ðеģ¬Ó¦¸Ã¸ÄΪ£º
SELECT * from [index] ORDER BY indexid DESC limit 0,10;
 
ÆäÖÐlimit 0,10±íʾ´ÓµÚ0 ......

SqLite ʱ¼ä¸ñʽ


sqliteʱ¼äº¯Êý£¨×ª£©
2007Äê12ÔÂ10ÈÕ ÐÇÆÚÒ» 13:33
תÌùÔ­Òò£º×î½üÉè¼ÆÁËÒ»¸ö¿çÊý¾Ý¿âµÄº¯Êý£¬À´²âÊÔ²âÊÔsqlite¡£
SQLite·ÖÒ³ÏÔʾ£ºSelect * from news order by id
desc Limit 10 Offset 10
ÕâƪÎÄÕÂÊǸù¾Ý SQLite ¹Ù·½ WIKI ÀïµÄÄÚÈÝ·­Ò룬Èç¹ûÓÐʲô·­Òë²»µ±µÄµØ·½Ï£Íû´ó¼ÒÖ¸³ö£¬±Ï¾¹ÎÒµÄÓ¢ÎÄˮƽʵÔںܲ SQ ......

SQLiteÃüÁîÐгÌÐò˵Ã÷

sqlite3: Ò»¸öSQLiteÊý¾Ý¿âµÄÃüÁîÐнӿÚ
ÒëÕß×¢
Ô­ÎĵØÖ·£ºhttp://www.sqlite.org/sqlite.html
    SQLite¿â°üº¬Ò»¸öÃû×Ö½Ð×ösqlite3 µÄÃüÁîÐÐ,Ëü¿ÉÒÔÈÃÓû§ÊÖ¹¤ÊäÈë²¢Ö´ÐÐÃæÏòSQLiteÊý¾Ý¿âµÄSQLÃüÁî¡£±¾ÎĵµÌṩһ¸öÑùʹÓÃsqlite3µÄ¼òҪ˵Ã÷¡£
¿ªÊ¼
    Æô¶¯sqlite3 ³ÌÐò£¬½ö½öÐèÒªÇÃÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ