Use of sqlite3 script and sqlite3 script

Source: Internet
Author: User

Use of sqlite3 script and sqlite3 script

I wanted to find a database-specific tool. Later I found that the script was very simple and I used the script directly.

The sqlite3 script allows you to conveniently view the content in the current database. It is actually very simple to use. This list some of the simplest usage. If more applications are available in the future


1) first import the database sqlite3 my. db

2) list all forms. tables

3) list the columns of the current table. schema my_table

4) view all the elements in a form, select * from table2;


For more information, see: http://www.sqlite.org/cli.html


How to Use SQLite

Sqliteis a file-type data warehouse with a command line tool sqlite3.exe (Windows version) and a third-party GUI tool (such as Database Browser, SQLiteman ...); but the more common method is to access your application or script through the corresponding interface.

When django dbshell uses sqlite, the following error occurs: 'sqlite3 'is neither an internal or external command, nor a runable program or batch file.

'Sqlite3 'is not an internal or external command
This statement indicates that sqlite3 in your code is probably at the wrong position.
If not, the configuration information is incorrect.
For sqlite3 configuration in django, you only need to write a database name and specify the database type. # The following prompt is displayed:

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.