????.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);
????4. ?Щ????? SQLite ????
????????????
????sqlite> .schema [table]
??????????б???????
????sqlite > .tables
??????????????????б??
????sqlite > .indices [table ]
????????????? SQL ?????
????sqlite > .output [filename ]
????sqlite > .dump
????sqlite > .output stdout
?????? SQL ????????????
????sqlite > .read [filename ]
????????????????? CSV ?????
????sqlite >.output [filename.csv ]
????sqlite >.separator ??
????sqlite > select * from test;
????sqlite >.output stdout
?????? CSV ???????????????У?
????sqlite >create table newtable ( id integer primary key?? value text );
????sqlite >.import [filename.csv ] newtable
?????????????
????/* usage: sqlite3 [database] .dump > [filename] */
????sqlite3 mytable.db .dump > backup.sql
????????????
????/* usage: sqlite3 [database ] < [filename ] */
????sqlite3 mytable.db < backup.sql