????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