????1. ????
????SQLite ????????????????????????????????????á?????????SQL????????檔 ??????????Я????÷???????????Ч??????? ?????????????????????SQLite ?????????з????????????????? - ?????SQLite???????????????????????????????????????????????????????????????????????????SQLite?????????
????2. ???
????SQLite on Windows
????1?????? SQL ??????棺http://www.sqlite.org/download.html
????2?????? Windows ?μ??????????????????
????sqlite-shell-win32-x86-<build#>.zip
????sqlite-dll-win32-x86-<build#>.zip
???????: <build#> ?? sqlite ?????汾??
?????? zip ??????????????????????????????????? PATH ?????У??????????????????? sqlite ???
???????: ??????????????? sqlite ????????ó?????????????????????????????? API
????sqlite-amalgamation-<build#>.zip
????SQLite on Linux
?????? ??? Linux ???а?????????????????? SQLite??
????/* For Debian or Ubuntu /*
????$ sudo apt-get install sqlite3 sqlite3-dev
????/* For RedHat?? CentOS?? or Fedora/*
????$ yum install SQLite3 sqlite3-dev
????SQLite on Mac OS X
????????????????Mac OS?????????°汾???????????????????SQLite???
????3. ???? SQLite ?????
?????????????????? SQLite ??????????????????????????????д????????????????????????????? test.db ???????
????sqlite3 test.db
???????????
????sqlite> create table mytable(id integer primary key?? value text);
????2 columns were created.
???????????????? id ????????κ??????? value ???????Ρ?
???????: ?????????????????????????????????????????????浽?????У??????????????????
??????????????????д???Щ?????
????sqlite> insert into mytable(id?? value) values(1?? 'Micheal');
????sqlite> insert into mytable(id?? value) values(2?? 'Jenny');
????sqlite> insert into mytable(value) values('Francis');
????sqlite> insert into mytable(value) values('Kerk');
????????????
????sqlite> select * from test;
????1|Micheal
????2|Jenny
????3|Francis
????4|Kerk
????????????????????
????sqlite> .mode column;
????sqlite> .header on;
????sqlite> select * from test;
????id          value
????----------- -------------
????1           Micheal
????2           Jenny
????3           Francis
????4           Kerk
????.mode column ????????????????.header ???????????
????????????????У?
????sqlite> alter table mytable add column email text not null '' collate nocase;;
?????????????
????sqlite> create view nameview as select * from mytable;
??????????????
????sqlite> create index test_idx on mytable(value);