sqlite3

.mode column;
.header on; 

alter table mytable
add column email text not null '' collate nocase;
create view nameview as select * from mytable;
create index test_idx on mytable(value);

.schema mytable
.tables
.indices mytable

.output bak.sql
.dump
.output stdout

.read bak.sql


.output data.csv
.separator ,
select * from mytable;
.output stdout

.import data.csv newtable

sqlite3 test.db .dump>backup.sql
sqlites test.db <backup.sql


----------------qqmusic.sh==================

#! /system/bin/sh

chmod 444 /data/data/com.tencent.qqmusic/lib/libpbpinyin.so
echo "delete session..."
cd /data/data/com.tencent.qqmusic/databases
rm data0.txt
sqlite3 QQMusic</mnt/sdcard/qqmusic/qqmusic.sql
cat data0.txt>>data.txt

echo "delete qmSfile..."
rm /mnt/sdcard/qqmusic/qmSfile
echo "ok!"


-----------------qqmusic.sql=========================
.output data0.txt

select * from session;

.output stdout

delete from session;