???С?????SQLite?????
???????????? ???????[ 2014/7/17 11:25:33 ] ????????SQLite?????
????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
|
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11