sqlite3????????
???????????? ???????[ 2014/1/21 11:28:24 ] ????????????? ????
????sqlite3???????????????????С?????ACID????
??????ACID?????????????????е??????????????д?????????????(Atomicity??????????Consistency???????????Isolation??????????Durability??????????????Transaction???????????????????????????????????????????????Transaction processing??????????????????????????????????????????????????
????/********************************************/
????sqlite??????????????????????
??????????
????1.???????????譎???????????
????2.????????????????е???????????????
????3.????????????????????????????????????
????4.?????????С??2TB??
????5.??С?????????????3????c????250KB;
????6.????????е??????????????????????
????/*******************************************/
????SQLite??????????黯??????8??????????鹹?????Щ???????????????????????????????齫???????????????С????????д????
????/*******************************************/
??????????????
????linux@ubuntu:~$ sqlite3 my.db
????????????
????sqlite> .help
??????????λ???
????sqlite> .database
?????????
????sqlite> .quit
?????????
????sqlite> .tables
?????????????
????sqlite> .schema
????1.?????
????sqlite> create table usr(id integer primary key?? name text??age integer null?? gender text?? salary real not null);
????2.?????
????sqlite> drop table usr??
????3.????
????sqlite> insert into usr(id?? name?? age?? salary) values(2?? 'liu'?? 20?? 6000);
????4.?
????sqlite> delete from usr where id = 2??
????5.???
????sqlite> update usr set gender = 'man' where id = 3;
????6.?飺
????sqlite> select * from usr where id = 2;
??????
???·???
??????????????????
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