sqlite3简单语句学习

sqlite> .output file.out
sqlite> .schema
sqlite> .database
sqlite> .tables
assignment            member                role_pam
centrify_sam_db_data  pam                   user_info
centrify_sam_stat1    role
command               role_cmd
sqlite> .dump member
sqlite> .dump assignment
sqlite>.quit

[2014-07-26  18:07:12 root@davidcchen wesoft] sudo sqlite3 /var/centrifydc/dz.cache 
        SQLite version 3.3.6
        Enter ".help" for instructions
        sqlite> .headers on
        sqlite> select * from role;