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

´´½¨sqlite µÄvs2008 ¹¤³Ì

      ½üÀ´ÒòΪ¹¤×÷ÐèÒª¼ÓÈësqlite ´¦ÀíÊý¾Ý£¬ÏÂÔØÁËsqlite3.6.22(amalgamation °æ±¾£©£¬ÓÖÏë×Ô¼º¶¯ÊÖ±àÒë³öÀ´Ï붯̬Á´½Ó¾Í¶¯Ì¬£¬Ï뾲̬Á´½ÓÒ²¿ÉÒÔ£¬ÓÚÊÇÓÐÁËÕâÆªÎÄÕ£¬ÓÐÒâ˼µÄÊÇ֮ǰҲÊÔ¹ý±àÒëSqlite£¬µ«Ã»³É¹¦£¬²»ÁËÁËÖ®£¬¿ÉÄܽüÀ´Òª¹ýÄêÁË
¸ú
RPÓйذÉ:)¡£
1 Ê×ÏÈ´´½¨vs2008µÄÒ»¸ö¿ÕDLL¹¤³Ì;
2 ½«sqlite3.cÎļþÌí¼Óµ½¹¤³Ì£¬²»ÐèÒªsqlite3.hÍ·Îļþ£¬sqlite3.cÒѾ­°üº¬ÁËÍ·ÎļþµÄ½Ó¿Ú¸úÊý¾Ý½á¹¹¡£
3. ×îÖØÒªµÄÒ»²½£¬½«±àÒëÑ¡ÏîÀïµÄ"±àÒë³ÉC++"¸ÄΪ“±àÒë³ÉC”£¬ÎÒÔÚGoogleÏֳɵÄsqlite vs¹¤³Ì·¢ÏÖÐí¶àÈ˶¼ÒòΪÄÇЩ·³È˵ÄÀàÐÍû¶¨Òå»òÕß²»Æ¥Åä±ÀÀ££¬ÐÞ¸ÄÕâ¸öÑ¡Ïîºó¾Í²»ÐèÒªÐ޸ĴúÂëÁË¡£
4. sqliteÍøÕ¾Ìṩһ¸öWindowsµÄ±àÒë¿â£¬ÎÒûÓõ½ÄǸöDLL£¬µ«ÄǸösqlite3.defÈ´¿ÉÒÔÓÃÀ´ÉùÃ÷µ¼³öº¯Êý£¬±È×Ô¼ºÈ¥µ¼³öÊ¡Á¦£¬ËùÒÔÒ²Ìí¼Ó½ø¹¤³Ì¡£
5 »¹ÓÐÒ»¸ö±àÒëºê£¬SQLITE_ENABLE_COLUMN_METADATA£¬Èç¹ûÓöµ½sqlite3_column_database_name**£¨£©º¯Êýû¶¨Ò壬ÄǾÍÊÇÌáÐÑÒª¼Ó½øÕâ¸öºêÁË£¬ÎÒÊÇÔÚ¹¤³Ì"ÊôÐÔ"¿ò------> C++ ------->Preprocessor-------->Preprocessor DefinitionÌí¼ÓµÄ£¬µ±È»Ò²¿ÉÒÔÔÚÆäËûµØ·½Ìí¼Ó£¬
µ«ÒÔÎÒµÄÏë·¨£¬ÔÚÕâÀïÌí¼Ó²»ÐèÒª¸Ä¶¯´úÂ룬¶øÇÒÒÔºósqlite°æ±¾Éý¼¶£¬Ö»ÐèÒªÔÚ¹¤³ÌĿ¼ÀïÌæ»»sqlite3.c ºÍsqlite3.def£¬Ò»ÀÍÓÀÒÝ£¬¡¡Ï£ÍûÈç´Ë°É£¡
6 Ìí¼ÓÁËÒ»¸ö°æ±¾ÐÅÏ¢£¬³£ÓÃVCµÄ¿Ï¶¨ÖªµÀ£¬°æ±¾Éý¼¶¾ÍÖ±½ÓÔÚsqlite_version.rcÀïÃæÐ޸İ汾ºÅ¾ÍÊÇÁË¡£
ÉÏ´«ÁËÒ»·Ýµ½CSDN£¬²»ÖªµÀCSDNµ½µ×ÔÚÄÄÀïÖ§³Ö¸½¼þÉÏ´«  :)
http://download.csdn.net/source/2022243


Ïà¹ØÎĵµ£º

SQLITEÈëÃÅ Öð²½½²½âSQLITEÃüÁîÐÐ(¶þ)

¿ÉÒÔ½Ó×ÅÉÏÒ»²½²Ù×÷£¬Ö±½ÓÏòDOS´°¿ÚÊäÈë.helpÃüÁîÀ´²é¿´SQLiteµÄËùÓÐÃüÁîÐм°½âÊÍÈçÏ£º
F:\>sqlite3
SQLite version 3.6.16
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .help
Ò²¿ÉÒÔctrl+c½áÊøÃüÁÏëDOS´°¿Ú ÊäÈësqlite3Ö´ÐкóÔÙÊäÈë.helpÃüÁîÈçÏ£º
F:\>sqli ......

SQLITEÈëÃÅ Öð²½½²½âSQLITEÃüÁîÐÐ(Îå)

.help ÏÔʾ°ïÖúÐÅÏ¢
.import FILE TABLE °ÑÎļþÖеÄÊý¾Ýµ¼Èëµ½±íÖÐ,¸÷×Ö¶ÎÓÃseparator£¨Ä¬ÈÏÊÇ"|"£©µÄֵΪ·Ö¸ô·û,ÏÂÃæÎÒÃǾٸöÀý×Ó¡£ ÎÒÃÇÔÚFÅÌϽ¨Ò»¸ödata.txtÎļþ£¬ÄÚÈÝÈçÏ£º
4|¿ªÔ´
5|¼¼Êõ
.importÃüÁî²Ù×÷ÈçÏ£º
sqlite> .import data.txt websites
sqlite>
²é¿´½á¹ûÈçÏ£º
sqlite> select * from ......

SqliteºÍSQLCEÔÚWindows Mobile 6ÉϵÄÐÔÄܶԱÈ

     ×î½ü¹«Ë¾ÐèÒª½«×ÀÃæÏµÍ³²¿Êðµ½PDAÉÏÃæÈ¥£¬Ñ¡ÔñÁËWM6×÷Ϊ²¿Êðƽ̨¡£ÔÚÑ¡ÔñÊý¾Ý¿â·½Ãæ³öÏÖÁËÒ»µã¹ËÂÇ£¬ÒòΪ¶ÔÓÚPDA¶øÑÔ£¬ÐÔÄÜÊÇÊ×Òª¿¼ÂǵÄÒòËØ¡£
     ÔÚ¿ªÔ´µÄÊý¾Ý¿âSqliteºÍSQLCEÖ®¼äÅÇ»²£¬ËùÒÔÕë¶ÔÕâ¸öÇé¿ö£¬¶ÔSqliteºÍSQLCEÔÚWM6ÉÏÃæ×öÁËÐÔÄܲâÊÔ¡£ÎÒÒ²½«×Ô¼ºÔÚ×ö²âÊÔ¹ý³ÌÖÐÅöµ ......

SQLITEÊý¾Ý±íÖ÷¼üÉèÖÃId×ÔÔö·½·¨

    ¸ã¶¨ÁËÒ»¸öÀ§ÈÅÐí¾ÃµÄÎÊÌ⣬ԭÀ´sqliteÖеÄÖ÷¼üÒ²ÊÇ¿ÉÒÔÉèÖÃΪ×ÔÔöµÄ£º£©·½·¨¾ÍÊÇÉùÃ÷Ϊ INTEGER PRIMARY KEY µÄ×ֶοÉÒÔ×Ô¶¯Ôö¼Ó¡£
    ÍøÉϲ鵽×ÊÁÏ˵£¬´Ó SQLite µÄ 2.3.4 °æ±¾¿ªÊ¼£¬Èç¹û½«Ò»¸ö±íÖеÄÒ»¸ö×Ö¶ÎÉùÃ÷Ϊ INTEGER PRIMARY KEY£¬ÄÇôֻÐèÏò¸Ã±íµÄ¸Ã×ֶβåÈëÒ»¸ö NULL Öµ£¬ ......

SQLiteÔÚVCϵÄʹÓÃ

Ò»¡¢SQLite¼ò½é
SQLite ÊÇÓÃCÓïÑÔ±àдµÄ¿ªÔ´Êý¾Ý¿â£¬Ö÷ÒªÓÃÓÚǶÈëʽ£¬ÄãÒ²¿ÉÒÔ°ÑËü¼¯³ÉÔÚ×Ô¼ºµÄ×ÀÃæ³ÌÐòÖУ¬Ò²ÓÐÈ˽«ÆäÌæ´úAccess£¬ÓÃ×÷ºǫ́Êý¾Ý¿â¡£
SQLite Ö§³Ö¶àÊýSQL92±ê×¼£¬ÀýÈ磺Ë÷Òý¡¢ÏÞÖÆ¡¢´¥·¢ºÍ²é¿´Ö§³Ö¡£
Ö§³Ö NULL¡¢INTEGER¡¢REAL¡¢TEXT ºÍ BLOB Êý¾ÝÀàÐÍ£¬Ö§³ÖÊÂÎñ¡£
¶þ¡¢ÏÂÔØSQLite
SQLite¿ÉÒÔµ½¹Ù·½Õ¾µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ