???С?????SQLite?????
???????????? ???????[ 2014/7/17 11:25:33 ] ????????SQLite?????
????.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
??????
???·???
??????????????????
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