打开数据库:sqlite3 /data/system.db
退出数据库:sqlite>.q
显示数据库中所有的表名 :sqlite>.tables
显示表头 :sqlite> .header on
切换输出格式(行模式): sqlite>.mode line
切换输出格式(列模式): sqlite>.mode column
查:SELECT * FROM table_name; select * from CodeValidTbl;
删:DELETE FROM table_name WHERE [condition]; delete from recordlib;
改:update aifaceking set bind_status = 0;
查表结构:select * from sqlite_master where type="table" and name="emperors";
查询数据库是否损坏:PRAGMA integrity_check;