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

SQLiteÊý¾Ý¿âµÄ¹Ò½Ó¼°³£ÓÃÃüÁî

°²×°:
¹Ù·½ÍøÕ¾ÏÂÔØ×îеÄsqlite°æ±¾
¹Ù·½ÍøÕ¾: http://www.sqlite.org/
ÏÂÔصØַΪ: http://www.sqlite.org/download.html
¹Ù·½µÄÏÂÔØÒ³ÃæÌṩÁ˺ܶà°æ±¾µÄÏÂÔØ…ÕâÀï½éÉÜÒ»ÏÂ;
Source Code: Ô´´úÂë°æ±¾µÄÏÂÔØ
Documentation:  Ïà¹ØÎĵµ
Precompiled Binaries for Linux / Precompiled Binaries For Mac OS X /
Precompiled Binaries For Windows
Linux/Mac/Win°æ±¾µÄÔ¤±àÒë°æ±¾
Èç¹ûÄãÖ»ÊÇÊý¾Ý¿âµÄÓû§ÄÇôÏÂÔØÒѾ­±àÒëºÃµÄ°æ±¾¼´¿É! ÕâÀïÎÒÊÇWinÓû§,ÏÂÔصÄÎļþΪ: sqlite3.exe
½«Õâ¸öÎļþ·Åµ½Ò»¸öĿ¼ÖÐ,ÕâÑù¾ÍÍê³ÉÁËÈ«²¿µÄsqliteÊý¾Ý¿âµÄ°²×°!
н¨:
ÔÚÃüÁîÌáʾ·ûÏÂ($ΪshellÌáʾºÅ), ²âÊÔµÄsqlite3.exe·¾¶Îªe:\sqlite3\sqlite3.exe
ÍøÉÏÒ²ÌṩÁ˺ܶ෽·¨,µ«ºÃÏó¶¼ÓеãÎÊÌâ,¾­¹ýÃþË÷½áÂÛΪÒÔϼ¸ÖÖ·½·¨,µ«²»È·¶¨ÊÇ·ñÊܲÙ×÷ϵͳϵͳӰÏì!
Éú³ÉÊý¾Ý¿âÎļþºó¹Ò½Ó
$> sqlite3.exe test.db ;
$> sqlite3.exe test.db
Ö±½Ó¹Ò½ÓÉú³É
$> sqlite3.exe test.db;
Ñ¡ÔñÐÔ¹Ò½Ó ÌôÑ¡ÒѾ­´æÔÚµÄÊý¾ÝÎļþ¹Ò½Ó
$> sqlite3.exe test.db »òÕß
$> sqlite3.exe e:\sqlite3\test.db
¹Ò½ÓºÃÊý¾Ý¿âºó,¾Í¿ÉÒÔͨ¹ýÃüÁîÐеÄÐÎʽ¶ÔËù¹Ò½ÓµÄÊý¾Ý¿â²Ù×÷ÁË!
   Cmd ½øÈëÃüÁîÐÐ
   1)
   ´´½¨Êý¾Ý¿âÎļþ:
   >SQLite3 d:\test.db »Ø³µ
   ¾ÍÉú³ÉÁËÒ»¸ötest.dbÔÚdÅÌ¡£
   ÕâÑùͬʱҲSQLite3¹ÒÉÏÁËÕâ¸ötest.db
   2)
   ÓÃ.help¿ÉÒÔ¿´¿´ÓÐʲôÃüÁî
   >.help »Ø³µ¼´¿É
   3)¿ÉÒÔÔÚÕâÀïÖ±½ÓÊäÈëSQLÓï¾ä´´½¨±í¸ñ ÓÃ;½áÊø£¬È»ºó»Ø³µ¾Í¿ÉÒÔ¿´µ½ÁË
   4)¿´¿´Óд´½¨Á˶àÉÙ±í
   >.tables
   5)¿´±í½á¹¹
   >.schema ±íÃû
   6)¿´¿´Ä¿Ç°¹ÒµÄÊý¾Ý¿â
   >.database
   7)Èç¹ûÒª°Ñ²éѯÊä³öµ½Îļþ
   >.output ÎļþÃû
   > ²éѯÓï¾ä£»
   ²éѯ½á¹û¾ÍÊä³öµ½ÁËÎļþc:\query.txt
   °Ñ²éѯ½á¹ûÓÃÆÁÄ»Êä³ö
   >.output stdout
   8)°Ñ±í½á¹¹Êä³ö£¬Í¬Ê±Ë÷ÒýÒ²»áÊä³ö
     .dump ±íÃû
   9)Í˳ö
   >.exit »òÕß.quit
sqlite¹Ù·½°ïÖúÌáʾÐÅÏ¢£º
sqlite> .help
.help
.bail ON|OFF 


Ïà¹ØÎĵµ£º

sqliteºÍpdo mysqlµÄÊý¾Ý¿â²Ù×÷

½ñÌìµÄѧϰÄÚÈÝÊÇsqliteºÍPDO mysql¡£
ÓÃ×Ô¼ºµÄ»°ËµËµÁ½¸ö¶«Î÷°É£º
sqliteËãÊÇÒ»ÖÖ²»ÏµÍ³µÄÊý¾Ý¿â´æ´¢·½Ê½£¬ËüµÄ´æ·Å¸ñʽÊÇÒ»¸ö.dbºó׺µÄÎļþ£¬ÔÚphpÖÐËü´æ·ÅÔÚµ±Ç°µÄĿ¼Ï£¬Ã²ËƲ»ÓÃÓû§ÃûÃÜÂ룬°²È«ÐԽϵͣ¬È´±È½Ï·½±ã¡£PHP5ÖÐ×Ô´øµÄһЩϵͳº¯Êý£¬¶¼ÊÇÒÔsqlite_¿ªÍ·µÄ¡£
PDOÈ«³ÆPHP Data Object£¬¹ËÃû˼Òå¾ÍÊÇPHPµÄÒ ......

Sqlite Êý¾Ý¿â

1¡¢SQLite¼ò½é
¡¡¡¡SQLiteµÚÒ»¸öAlpha°æ±¾µ®ÉúÓÚ2000Äê5ÔÂ. ÖÁ½ñÒѾ­ÓÐ9¸öÄêÍ·ÁË. SQLiteÒ²Ó­À´ÁËÒ»¸ö°æ±¾ SQLite 3ÒѾ­·¢²¼.
¡¡¡¡SQLiteÊÇÒ»¿îÇáÐ͵ÄÊý¾Ý¿â£¬ÊÇ×ñÊØACIDµÄ¹ØÁªÊ½Êý¾Ý¿â¹ÜÀíϵͳ£¬ËüµÄÉè¼ÆÄ¿±êÊÇǶÈëʽµÄ£¬¶øÇÒÄ¿Ç°ÒѾ­ÔںܶàǶÈëʽ²úÆ·ÖÐʹÓÃÁËËü£¬ËüÕ¼ÓÃ×ÊÔ´·Ç³£µÄµÍ£¬ÔÚǶÈëʽÉ豸ÖУ¬¿ÉÄÜÖ»ÐèÒª¼¸°ÙKµ ......

javaÖÐʹÓÃsqliteÊý¾Ý¿â

sqliteÊý¾Ý¿âµÚÈý·½javaÀ©Õ¹°üÏÂÔصØÖ·£ºhttp://www.zentus.com/sqlitejdbc/
ÓÐ2¸ö°ü£¬Ò»¸öÊÇnested£¨Ç¶ÈëʽµÄ£©£¬Ò»¸öÊÇnative(±¾µØµÄ)¡£
Çø±ðÔÚÓÚ:nested ²»ÐèÒª¶îÍâµÄdllÎļþ£¬µ«ÊÇËÙ¶ÈÂý¡£nativeÐèÒªÒ»¸ö¶îÍâµÄdllÎļþ£¬ËٶȺܿ졣
 1.ʹÓÃnested°ü£ºsqlitejdbc-v037-nested.jar
java´úÂ룺
java ´úÂë
packa ......

Windows MobileÏ·ÃÎÊSqliteµÄNative C++·â×°

±³¾°
µ±Ç°Òƶ¯É豸¿ª·¢ÁìÓò£¬ÔÚ±¾µØÊý¾Ý´æ´¢·½Ã棬Sqlite¼¸ºõ³ÉÁËÊÂʵ±ê×¼£¬Andriod (android.database.sqlite)£¬iPhone (SQLite for iPhone SDK ºÍ FMDB for iPhone)£¬Palm WebOS (webOS SQL Tutorial)£¬Ð°汾µÄSymbianÒ²Ö±½Óbuilt-in SqliteÁË(20 million Symbian smartphones shipped in Q3 2007 Newer versions of th ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ