2010ÄêSQLiteѧϰ±Ê¼ÇÖ®Ò»
2010ÄêSQLiteѧϰ±Ê¼ÇÖ®Ò»
Ò»£® ÈçºÎ»ñÈ¡SQLite×îа汾
¹Ù·½Õ¾µã£ºhttp://www.sqlite.org/
´Óhttp://www.sqlite.org/ÍøÕ¾µÄDownloadÒ³Ãæ»ñÈ¡
¼´ÈçÏÂÒ³ÃæÏÂÔØ
http://www.sqlite.org/download.html
¶þ£®WindowsϵÄSQLiteµÄÔ´´úÂëÊÇÄĸöÈí¼þѹËõ°ü£¿
sqlite-amalgamation-3_6_22.zipÊÇSQLiteµÄwindowsÏÂÔ´ÂëÎļþ
Èý£®WindowϵÄSQLiteÃüÁîÐй¤¾ß
sqlite-3_6_22.zip
ËÄ£®WindowϵÄSQLite¿ª·¢¿â£¬¼´¶¯Ì¬Á´½Ó¿âÒÔ¼°DEFÎļþ
sqlitedll-3_6_22.zip
Î壮SQLite×îа汾ÊÇ£º3.6.22
Áù£®b<=a && a <= c µÄSQLÓï¾äÈçºÎд
ÔÚSQLiteÖÐ, ±í´ïʽ"a BETWEEN b AND c"µÈÓÚ±í´ïʽ "a >= b AND a <= c",ÔڱȽϱí´ïʽʱ,a¿ÉÒÔÊǾßÓÐÈκÎÇ׺ÍÐÔ
Æß£®aµÄÖµÊÇx,y,zÆäÖÐÒ»¸öÖµ£¬SQLÓï¾äÈçºÎд
SQLite°Ñ±í´ïʽ "a IN (x, y, z)" ºÍ "a = z OR a = y OR a = z"ÊÓΪÏàµÈ.
°Ë£®ÈçºÎ´´½¨Öƶ¨Ä¿Â¼µÄÊý¾Ý¿â
sqlite3 D:\Project\SyncML\Lib\debug\atsync.db
¾Å£®´´½¨Êý¾ÝµÄ×¢ÒâÊÂÏî
Èç¹û²»ÍùÊý¾Ý¿âÀïÃæÌí¼ÓÈÎºÎµÄ±í£¬Õâ¸öÊý¾Ý¿âµÈÓÚûÓн¨Á¢£¬²»»áÔÚÓ²ÅÌÉϲúÉúÈκÎÎļþ£¬Èç¹ûÊý¾Ý¿âÒѾ´æÔÚ£¬Ôò»á´ò¿ªÕâ¸öÊý¾Ý¿â¡£
Ê®£®ÈçºÎÌí¼ÓÒ»ÕÅÊý¾Ý±í
create table student(name varchar(10), age smallint);
ʮһ£®ÈçºÎÍùÊý¾Ý±íÖÐÌí¼ÓÊý¾Ý
insert into student values('ÕÅÈý', 20);
Ê®¶þ£®ÈçºÎͨ¹ýsqlite3.dllÓësqlite3.defÉú³Ésqlite3.libÎļþ
LIB /DEF:sqlite3.def /machine:IX86
Ê®Èý£®ÈçºÎ²éѯSQLite¹¤¾ßµÄÈí¼þ°æ±¾
Ò²¾ÍÊÇsqlite3.exeÓ¦ÓóÌÐòС¹¤¾ßµÄ°æ±¾ºÅ
·½·¨Ò»£º½øÈësqlite3.exeËùÔÚĿ¼£¬ÔÚÃüÁîÐÐÖ´ÐÐÈçÏÂÃüÁî
sqlite3 –version
·½·¨¶þ£º
select sqlite_version();
Ê®ËÄ£®ÈçºÎÔÚ×Ö·û´®ÖÐʹÓõ¥ÒýºÅ(')£¿
SQL ±ê×¼¹æ¶¨£¬ÔÚ×Ö·û´®ÖУ¬µ¥ÒýºÅÐèҪʹÓÃÌÓÒÝ×Ö·û£¬¼´ÔÚÒ»ÐÐÖÐʹÓÃÁ½¸öµ¥ÒýºÅ
Ê®Î壮Èç¹ûɾ³ýÁË´óÁ¿Êý¾Ý£¬¶øÓÖÏëËõСÊý¾Ý¿âÎļþÕ¼ÓõĿռ䣬ִÐÐ VACUUM ÃüÁî
vacuum;
Ê®Áù£®ÔÚSQLiteÖУ¬ÈçºÎÔÚÒ»¸ö±íÉÏÌí¼Ó»òɾ³ýÒ»ÁУ¿
SQLite ÓÐÓÐÏÞµØ ALTER TABLE Ö§³Ö¡£Äã¿ÉÒÔʹÓÃËüÀ´ÔÚ±íµÄĩβÔö¼ÓÒ»ÁУ¬¿É¸ü¸Ä±íµÄÃû³Æ¡£ Èç¹ûÐèÒª¶Ô±í½á¹¹×ö¸ü¸´Ôӵĸı䣬Ôò±ØÐëÖØÐ½¨±í¡£ ÖØ½¨Ê±¿ÉÒÔÏȽ«ÒÑ´æÔÚµÄÊý¾Ý·Åµ½Ò»¸öÁÙʱ±íÖУ¬É¾³ýÔ±í£¬ ´´½¨ÐÂ±í£¬È»ºó½«Êý¾Ý´ÓÁÙʱ±íÖи´ÖÆ»ØÀ´¡£
È磬¼ÙÉèÓÐÒ»¸ö t1 ±í£¬ÆäÖÐÓÐ "a", "b
Ïà¹ØÎĵµ£º
backup ?DB? FILE ±¸·ÝÊý¾Ý¿âµ½Îļþ£¬Ä¬Èϱ¸·ÝµÄÊÇmainÊý¾Ý¿â,Èç¹û²»¸½¼ÓÊý¾Ý¿â£¬test.dbÎļþÖÐĬÈϵÄÖ»ÓÐmainÊý¾Ý¿â¡£ ÃüÁî²Ù×÷¾ÙÀý£º
sqlite> .backup mydb.bak
sqlite>
´Ëʱ¿ÉÒÔÔÙFÅÌ¿´µ½mydb.bakÎļþ£¬ÓüÇʱ¾´ò¿ªËäÈ»ÊÇÂÒÂ룬µ«¿É¿ú¼ûÒ»°ß¡£
.restore ?DB? FILE ´Ó±¸·ÝÎļþ»¹ÔÊý¾ÝºÍ.backupÏà¶ÔÓ¦. ½ÓÉÏ ......
.help ÏÔʾ°ïÖúÐÅÏ¢
.import FILE TABLE °ÑÎļþÖеÄÊý¾Ýµ¼Èëµ½±íÖÐ,¸÷×Ö¶ÎÓÃseparator£¨Ä¬ÈÏÊÇ"|"£©µÄֵΪ·Ö¸ô·û,ÏÂÃæÎÒÃǾٸöÀý×Ó¡£ ÎÒÃÇÔÚFÅÌϽ¨Ò»¸ödata.txtÎļþ£¬ÄÚÈÝÈçÏ£º
4|¿ªÔ´
5|¼¼Êõ
.importÃüÁî²Ù×÷ÈçÏ£º
sqlite> .import data.txt websites
sqlite>
²é¿´½á¹ûÈçÏ£º
sqlite> select * from ......
Ò»¡¢SQLite¼ò½é
SQLite ÊÇÓÃCÓïÑÔ±àдµÄ¿ªÔ´Êý¾Ý¿â£¬Ö÷ÒªÓÃÓÚǶÈëʽ£¬ÄãÒ²¿ÉÒÔ°ÑËü¼¯³ÉÔÚ×Ô¼ºµÄ×ÀÃæ³ÌÐòÖУ¬Ò²ÓÐÈ˽«ÆäÌæ´úAccess£¬ÓÃ×÷ºǫ́Êý¾Ý¿â¡£
SQLite Ö§³Ö¶àÊýSQL92±ê×¼£¬ÀýÈ磺Ë÷Òý¡¢ÏÞÖÆ¡¢´¥·¢ºÍ²é¿´Ö§³Ö¡£
Ö§³Ö NULL¡¢INTEGER¡¢REAL¡¢TEXT ºÍ BLOB Êý¾ÝÀàÐÍ£¬Ö§³ÖÊÂÎñ¡£
¶þ¡¢ÏÂÔØSQLite
SQLite¿ÉÒÔµ½¹Ù·½Õ¾µ ......
OS X×Ô´Ó10.4ºó°ÑSQLiteÕâÌ×Ï൱³öÃûµÄÊý¾Ý¿âÈí¼þ£¬·Å½øÁË×÷ҵϵͳ¹¤¾ß¼¯Àï¡£OS X°ü×°µÄÊǵÚÈý°æµÄSQLite£¬ÓÖ³ÆSQLite3¡£ÕâÌ×Èí¼þÓм¸¸öÌØÉ«£º
Èí¼þÊôÓÚ¹«¹²²Æ£¨public domain£©£¬SQLite¿É˵ÊÇijÖÖ¡¸ÃÀµÂÈí¼þ¡¹£¨virtueware£©£¬×÷Õß±¾ÈË·ÅÆú×Å×÷Ȩ£¬¶ø¸øÊ¹ÓÃSQLiteµÄÈËÒÔϵġ¸×£¸£¡¹£¨blessing£©£º
May you do good an ......
ÒªÓÃASPÀ´²Ù×÷SQLiteÊý¾Ý¿â£¬Ç°ÌáÌõ¼þÊÇÔÚ·þÎñÆ÷Éϵð²×°SQLiteµÄODBCÇý¶¯³ÌÐò£¬¿Éµ½Õâ¸öÕ¾µãÉÏÏÂÔØ°²×°£ºhttp://www.ch-werner.de/sqliteodbc/£¬°²×°ºÃºó¾Í¿ÉÒÔÏñʹÓÃAccessÒ»ÑùÀ´Ê¹ÓÃSQLiteÁË£¡Ï±ßÊÇÒ»¸öSQLiteÊý¾Ý¿â½á¹¹£º
ÒýÓÃÄÚÈÝ
Create TABLE admin(username text,age integer);
ÎÒÃÇÔÙÀ´ÓÃASPÑÝʾÏÂÈçºÎ¶ÔSQLi ......