进入到sqlite3 数据库所在的目录下,敲入:
sqlite3 database.db(数据库名)
SQLite version 3.7.4
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>.table 数据库里所有表格
auth_group django_content_type
auth_group_permissions django_session
auth_permission django_site
auth_user yytag_filedata
auth_user_groups yytag_tag
auth_user_user_permissions yytag_yytaguser
django_admin_log
其他操作:
sqlite> create table admin(username text,age integer);sqlite> insert into admin values('kuang',25);
sqlite> select * from admin;
sqlite> update admin set username='kk',age=24 where username='kuang' and age=25;
sqlite> delete from admin where username='kk';
.help 查看帮助文档