android sqlite3命令

adb shell

sqlite3 /data/data/...../databases/.....db

.tables

select * from sqlite_master where type = "table" and name = "表名"

使用本机自带时间创建纪录时自动插入：

create table time (id integer , updateTime timestamp not null default ( datetime('now', 'localtime')));