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ËãÊÇÒ»ÖÖ²»ÏµÍ³µÄÊý¾Ý¿â´æ´¢·½Ê½£¬ËüµÄ´æ·Å¸ñʽÊÇÒ»¸ö.dbºó׺µÄÎļþ£¬ÔÚphpÖÐËü´æ·ÅÔÚµ±Ç°µÄĿ¼Ï£¬Ã²ËƲ»ÓÃÓû§ÃûÃÜÂ룬°²È«ÐԽϵͣ¬È´±È½Ï·½±ã¡£PHP5ÖÐ×Ô´øµÄһЩϵͳº¯Êý£¬¶¼ÊÇÒÔsqlite_¿ªÍ·µÄ¡£
PDOÈ«³ÆPHP Data Object£¬¹ËÃû˼Òå¾ÍÊÇPHPµÄÒ ......
1¡¢SQLite¼ò½é
¡¡¡¡SQLiteµÚÒ»¸öAlpha°æ±¾µ®ÉúÓÚ2000Äê5ÔÂ. ÖÁ½ñÒѾÓÐ9¸öÄêÍ·ÁË. SQLiteÒ²ÓÀ´ÁËÒ»¸ö°æ±¾ SQLite 3ÒѾ·¢²¼.
¡¡¡¡SQLiteÊÇÒ»¿îÇáÐ͵ÄÊý¾Ý¿â£¬ÊÇ×ñÊØACIDµÄ¹ØÁªÊ½Êý¾Ý¿â¹ÜÀíϵͳ£¬ËüµÄÉè¼ÆÄ¿±êÊÇǶÈëʽµÄ£¬¶øÇÒÄ¿Ç°ÒѾÔںܶàǶÈëʽ²úÆ·ÖÐʹÓÃÁËËü£¬ËüÕ¼ÓÃ×ÊÔ´·Ç³£µÄµÍ£¬ÔÚǶÈëʽÉ豸ÖУ¬¿ÉÄÜÖ»ÐèÒª¼¸°ÙKµ ......
sqliteÊý¾Ý¿âµÚÈý·½javaÀ©Õ¹°üÏÂÔصØÖ·£ºhttp://www.zentus.com/sqlitejdbc/
ÓÐ2¸ö°ü£¬Ò»¸öÊÇnested£¨Ç¶ÈëʽµÄ£©£¬Ò»¸öÊÇnative(±¾µØµÄ)¡£
Çø±ðÔÚÓÚ:nested ²»ÐèÒª¶îÍâµÄdllÎļþ£¬µ«ÊÇËÙ¶ÈÂý¡£nativeÐèÒªÒ»¸ö¶îÍâµÄdllÎļþ£¬ËٶȺܿ졣
1.ʹÓÃnested°ü£ºsqlitejdbc-v037-nested.jar
java´úÂ룺
java ´úÂë
packa ......
±³¾°
µ±Ç°Òƶ¯É豸¿ª·¢ÁìÓò£¬ÔÚ±¾µØÊý¾Ý´æ´¢·½Ã棬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 ......