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