安装Django的时候会自动把sqlite数据库安装上,下面介绍如何操作sqlite数据库:
1 进入你创建的目录,在终端运行 sqlite3 DBname.db
2 进入后输入.help可以查看帮助文档
3 .tables 可以要看sqlite3中有哪些表
select * from tablename; 查看数据
具体操作命令:
- [root@10 src]# cd rietveld
- [root@10 rietveld]# ls
- apache.conf.example dev.db Makefile README settings.pyc TODO upload.py.orig
- codereview __init__.py manage.py rietveld_helper static UPDATES
- codereview.wsgi.example __init__.pyc patches settings.py templates upload.py
- [root@10 rietveld]# sqlite3 dev.db
- sqlite version 3.6.20
- Enter ".help" for instructions
- Enter sql statements terminated with a ";"
- sqlite> .tables
- auth_group codereview_issue
- auth_group_permissions codereview_message
- auth_message codereview_patch
- auth_permission codereview_patchset
- auth_user codereview_repository
- auth_user_groups django_admin_log
- auth_user_user_permissions django_content_type
- codereview_account django_session
- codereview_branch django_site
- codereview_bucket gae2django_reftestmodel
- codereview_comment gae2django_regressiontestmodel
- codereview_content
- sqlite> select * from auth_user;
- 1|root|||root@root.com|sha1$dac64$c7c81d89f0ff8f8cedefc95ad59a3849cf705f12|1|1|1|2012-09-20 23:43:39.161264|2012-09-20 03:54:33.257231
- 2|tao.lu|||tao.lu@autonvai.com|sha1$fff77$7b4c631f4a6bf2b216dab658d853b3ef98d81906|0|1|0|2012-09-20 22:21:14|2012-09-20 22:20:56
- sqlite> .help
- .backup ?DB? FILE Backup DB (default "main") to FILE
- .bail ON|OFF Stop after hitting an error. Default OFF
- .databases List names and files of attached databases
- .dump ?TABLE? ... Dump the database in an sql text format
- If TABLE specified,only dump tables matching
- LIKE pattern TABLE.
- .echo ON|OFF Turn command echo on or off
- .exit Exit this program
- .explain ON|OFF Turn output mode suitable for EXPLAIN on or off.
- .genfkey ?OPTIONS? Options are:
- --no-drop: Do not drop old fkey triggers.
- --ignore-errors: Ignore tables with fkey errors
- --exec: Execute generated sql immediately
- See file tool/genfkey.README in the source
- distribution for further information.
- .header(s) ON|OFF Turn display of headers on or off
- .help Show this message
- .import FILE TABLE Import data from FILE into TABLE
- .indices ?TABLE? Show names of all indices
- If TABLE specified,only show indices for tables
- matching LIKE pattern TABLE.
- .load FILE ?ENTRY? Load an extension library
- .mode MODE ?TABLE? Set output mode where MODE is one of:
- csv Comma-separated values
- column Left-aligned columns. (See .width)
- html HTML <table> code
- insert sql insert statements for TABLE
- line One value per line
- list Values delimited by .separator string
- tabs Tab-separated values
- tcl TCL list elements
- .nullvalue STRING Print STRING in place of NULL values
- .output FILENAME Send output to FILENAME
- .output stdout Send output to the screen
- .prompt MAIN CONTINUE Replace the standard prompts
- .quit Exit this program
- .read FILENAME Execute sql in FILENAME
- .restore ?DB? FILE Restore content of DB (default "main") from FILE
- .schema ?TABLE? Show the CREATE statements
- If TABLE specified,only show tables matching
- LIKE pattern TABLE.
- .separator STRING Change separator used by output mode and .import
- .show Show the current values for varIoUs settings
- .tables ?TABLE? List names of tables
- If TABLE specified,only list tables matching
- LIKE pattern TABLE.
- .timeout MS Try opening locked tables for MS milliseconds
- .width NUM NUM ... Set column widths for "column" mode
- .timer ON|OFF Turn the cpu timer measurement on or off
- sqlite>