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

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


.nullvalue STRING ÓÃSTRING´úÌænullÖµÏÔʾ,²»ÄÑÀí½â£¬¾Í²»ÔÙÀÛÊöÁË¡£
.output FILENAME ÉèÖðѲéѯÊä³öµ½Îļþ,ºóÃæµÄÊä³ö½á¹û¶¼±£´æµ½ÎļþÖÐ,È磺
sqlite> .mode list
sqlite> .output websites.txt
sqlite> select * from websites;
sqlite>
¿ÉÒÔÔÚFÅÌÏ·¢ÏÖ½¨Á¢ÁËwebsites.txtÎļþ£¬ÆäÄÚÈÝÈçÏ£º
1|CTOChina.net
2|ËѺü
3|ÑÅ»¢
4|¿ªÔ´
5|¼¼Êõ
.output stdout ÉèÖðѲéѯ½á¹ûÊä³öµ½ÆÁÄ»,ÕâÊÇĬÈÏÊä³ö·½Ê½¡£È磺
sqlite> .output stdout
sqlite> select * from websites;
1|CTOChina.net
2|ËѺü
3|ÑÅ»¢
4|¿ªÔ´
5|¼¼Êõ
sqlite>
.prompt MAIN CONTINUE Replace the standard prompts(ÐÞ¸ÄÌáʾ·û)Çë²¹³ä£¿
.quit Í˳öSQLite³ÌÐò£¬Í¬.exitÃüÁî
.read FILENAME Execute SQL in FILENAME Ö´ÐÐÎļþÖеÄSQLÓï¾ä,ÎļþÖеÄÓï¾äÒ»¶¨Òª´øÉÏ·ÖºÅ(;).
ÎÒÃÇÔÚFÅÌϽ¨sqldata.txtÎļþ£¬ÆäÄÚÈÝΪ:
insert into websites(WebName) values('²âÊÔ²åÈëÊý¾Ý0');
insert into websites(WebName) values('²âÊÔ²åÈëÊý¾Ý1');
select * from websites;
ÎÒÃÇÖ´ÐÐ.readÃüÁîÈçÏ£º
sqlite> .read sqldata.txt
1|CTOChina.net
2|ËѺü
3|ÑÅ»¢
4|¿ªÔ´
5|¼¼Êõ
6|²âÊÔ²åÈëÊý¾Ý0
7|²âÊÔ²åÈëÊý¾Ý1
sqlite>
.schema ?TABLE? Show the Create statements ÒÔSQL¸ñʽÊä³ö±í½á¹¹,È磺
sqlite> .schema websites
CREATE TABLE [websites] (
[WebID] INTEGER NOT NULL PRIMARY KEY,
[WebName] VARCHAR(20) NULL
);
CREATE INDEX mytestindex on websites([webID]);
sqlite>
.separator STRING Change separator used by output mode and .import Ð޸ķָô·û,È磺
sqlite> select * from websites limit 4;
1|CTOChina.net
2|ËѺü
3|ÑÅ»¢
4|¿ªÔ´
sqlite> .separator /
sqlite> select * from websites limit 4;
1/CTOChina.net
2/ËѺü
3/ÑÅ»¢
4/¿ªÔ´
sqlite>
.show Show the current values for various settings ÏÔʾÅäÖÃÐÅÏ¢,È磺
sqlite> .show
echo: off
explain: off
headers: off
mode: list
nullvalue: ""
output: stdout
separator: "/"
width:
sqlite>
.tables ?PATTERN? List names of tables matching a LIKE pattern ÏÔʾ¿âÖбíµÄÁÐ±í¡£
.timeout MS Try opening locked tables for MS milliseconds ³¬Ê±Ê±¼ä,µ¥Î»:ºÁÃë
.width NUM NUM ... Set c


Ïà¹ØÎĵµ£º

ǶÈëʽÊý¾Ý¿â SQLite ¼ò½é

 ×Ô¼¸Ê®Äêǰ³öÏÖµÄÉÌÒµÓ¦ÓóÌÐòÒÔÀ´£¬Êý¾Ý¿â¾Í³ÉΪÈí¼þÓ¦ÓóÌÐòµÄÖ÷Òª×é³É²¿·Ö¡£ÕýÓëÊý¾Ý¿â¹ÜÀíϵͳ·Ç³£¹Ø¼üÒ»Ñù£¬ËüÃÇÒ²±äµÃ·Ç³£ÅӴ󣬲¢Õ¼ÓÃÁËÏ൱¶àµÄϵ
ͳ×ÊÔ´£¬Ôö¼ÓÁ˹ÜÀíµÄ¸´ÔÓÐÔ¡£Ëæ×ÅÈí¼þÓ¦ÓóÌÐòÖð½¥Ä£¿éÄ£¿é»¯£¬Ò»ÖÖÐÂÐÍÊý¾Ý¿â»á±È´óÐ͸´ÔӵĴ«Í³Êý¾Ý¿â¹ÜÀíϵͳ¸üÊÊÓ¦¡£Ç¶ÈëʽÊý¾Ý¿âÖ±½ÓÔÚÓ¦ÓóÌÐò½ø³Ì
ÖÐ ......

railsʹÓÃsqlite3ºÍmysqlµÄÎÊÌâ

1¡¢Èç¹ûʹÓÃsqlite3ʱ³öÏÖÈçÏ´íÎó£º
/!\ FAILSAFE /!\  Thu Jul 30 22:16:15 +0800 2009
  Status: 500 Internal Server Error
  unknown error
    c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `initialize'
    c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `dlopen'
&nb ......

SQLiteÖеÄÈ«ÎÄËÑË÷

    °ÝGoogleµÄScott Hessͬ־Ëù´Í£¬SQLiteÒ²ÍÆ³öÁËÈ«ÎÄËÑË÷¹¦ÄÜ¡£
    SQLiteͨ¹ý½¨Á¢Ò»¸öÐéÄâ±í£¬½«ÊäÈëµÄÎÄ×Ö¸ù¾Ý¿Õ¸ñ¡¢±êµã·ûºÏµÈ¹æÔò½øÐзִʣ¬×éÖ¯³ÉÒ»¿ÃBÊ÷£¬ÒÔ´ËÀ´Ìá¸ßËÑË÷ËÙ¶È¡£
    ÈçºÎʹÓÃÕâÒ»¹¦ÄÜ£¬ÐÔÄÜÉÏÈçºÎ£¬´ó¼Ò¸÷×ÔÑо¿È¥°É¡£
    ÔÚÕâÀ ......

Sqlite DBʹÓÃÀý×Ó

ǰһÕó×Ö×öÏîÄ¿(ǶÈëʽlinux)£¬ÓÉÓÚÒª±£´æ´óÁ¿µÄÊý¾Ý£¬¶øÇÒ×Ҫ±£´æ30ÌìµÄʱ¼ä¡£±¾À´´òËã±£´æµ½ÎļþÖУ¬Ã¿´ÎÆô¶¯Ó¦ÓóÌÐòµÄʱºòÖØÐ½âÎöÒ»±é£¬¿ÉÊǵ±Êý¾ÝÁ¿ºÜ´óµÄʱºò£¬¾Í³öÏÖЧÂʵÄÎÊÌâÁË¡£ËùÒÔ×îºó»¹ÊÇ·ÅÆúÁËʹÓÃÎļþµÄ´òË㣬¾ö¶¨Ê¹ÓÃÊý¾Ý¿â´æÈ¡Êý¾Ý¡£
linuxϵÄÊý¾Ý¿âÒ²ºÜ¶à£¬ÓпªÔ´µÄ£¬Ò²ÓÐÊշѵġ£¶ÔÓÚÎÒÃÇÀ´Ëµ£¬¿Ï ......

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

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