Use of sqlite3 script and sqlite3 script

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: