Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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²éѯÊý¾Ý¿âÖдæÔÚµÄËùÓбí

from within a C/C++ program (or a script using Tcl/Ruby/Perl/Python
bindings) you can get access to table and index names by doing a SELECT
on a special table named "SQLITE_MASTER
". Every SQLite database has an SQLITE_MASTER table that defines the schema for the database.
SQL code
S ......

×ö¸ö±ê¼Ç£¬ÔÚAndroidÖÐʹÓÃÍøÂçÏÂÔØµÄsqliteÎļþ

ÏȼÇÏÂÀ´£º
FileOutputStream outputStream = openFileOutput("mydb", 0);
InputStream inputStream = response.getEntity().getContent();
byte[] data = new byte[bufferSize];
for (int i = inputStream.read(data); i > 0; i = inputStream
        .read(data)) {
& ......

ǶÈëʽÊý¾Ý¿âµäÐͼ¼Êõ¨DSQLiteºÍBerkeley DBµÄÑо¿

Õª Òª: Óë³£¼ûµÄÊý¾Ý¿âÏà±È£¬Ç¶Èëʽ
Êý
¾Ý¿â¾ßÓÐÌå»ýС¡¢¹¦ÄÜÆë±¸¡¢¿ÉÒÆÖ²ÐÔ¡¢½¡×³ÐÔµÈÌØµã£¬±¾ÎÄ·ÖÎöºÍ±È½ÏÁ˵äÐ͵ÄǶÈëʽÊý¾Ý¿âSQLiteºÍBerkeley DB¡£Ê×ÏÈ´ÓÌåϵ½á¹¹¡¢×Óϵͳ
¼äµ÷ÓùØÏµ¡¢ÈÎÎñÖ´Ðйý³ÌµÈ½Ç¶È¶ÔSQLiteºÍBerkeley DB½øÐÐÁËÏêϸ·ÖÎö£¬È»ºóÖØµã´ÓÊý¾ÝÀàÐÍ¡¢´æ´¢·½Ê½¡¢Ä£Ê½¡¢Êý¾Ý¿âÒýÇ ......

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
µÄ×îа汾¿ÉÒÔ´ÓÕâÀïÏÂÔØ
¡£ÏÂÃæÎÒÃÇÒÔWindows°æ±¾sqlite-3_5_1.zip
ΪÀý½éÉÜÆä°²×°·½·¨¡£
£¨´ó¼Ò¿ÉÒÔÑ¡ÔñÏÂÔØ°²×°ÊʺÏ×Ô¼ºµÄ°æ±¾£©
ÏÂÔØºó£¬½«sqlite-3_5_1.zip½âѹËõÖÁC:\sqliteĿ¼¼´Íê³É°²×°¡£
C:\sqliteĿ¼¹¹ÔìΪ£º
C:\sqlite
  |
  +--sqlite3.exe
´ò¿ªÒ»¸öCMDÃüÁî´°¿Ú
C:\ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ