Create a database file :

>SQLite3 d:\test.db enter

I just generated one test.db stay d disc .

So at the same time SQLite3 Put this on test.db


use .help You can see what the orders are

>.help You can enter.

3) You can enter it directly here SQL Statement to create a table , use ; end , Then enter and you'll see

4) See how many tables have been created


5) Look at the structure of the watch

>.schema Table name

6) Take a look at the database you're currently hanging on to


7) If you want to output the query to a file

>.output file name

> Query statement ;

The query result is output to the file c:\query.txt

Output the query results on the screen

>.output stdout

8) Output the table structure , At the same time, the index will output

.dump Table name

9) sign out

>.exit perhaps .quit

SQLite More articles on common commands

  1. Sqlite Common commands and basic knowledge

      sqlite Novice tutorial :http://www.runoob.com/sqlite/sqlite-tutorial.html   Common commands : .sqlite3 -- from dos Command mode to enter sqlite command ...

  2. SQLite Common commands

    1. Click command [ sign out SQLite Prompt ] .quit .exit [ help ] .help [ Display settings ] .show 2. grammar [ Terminator ] : -- A line ends with a semicolon (:) ending [CREATE TABLE ...

  3. sqlite Common commands

    1) Create a database file : >sqlite3 /home/test.db enter I just generated one test.db stay /home Under the path . So at the same time SQLite3 Loaded this test.db 2) use .help You can see ...

  4. Android SQLite3 Tool common command line summary

    Android SDK Of tools There is a sqlite3.exe Tools , This is an easy one sqlite Database management tools . Developers can easily use it to sqlite Database for command line operations . The program runs and generates *. ...

  5. sqlite Common commands - Additions and deletions

    One . View version information : #sqlite3 -version Two .sqlite3 Common commands 1. Create or open... In the current directory test.db Database files , And enter sqlite Command terminal , With sqlite> Prefix identification : 2. ...

  6. Android-adb Common commands and sqlite

    Android In the development environment ,ADB It's us doing Android Debugging tools often used in development , It's for us, of course Android What developers have to master . ADB summary Android Debug Bridge,Androi ...

  7. 54. Android in adb Common command and application common directory

    This paper mainly introduces adb Common command and application common directory .1.adb Common commands adb devices List all connected android equipment . The following commands are all for a single devices for , If there are multiple devices Words , The following commands all need ...

  8. sqlite3 Common commands & grammar

    sqlite The database only needs one file ok, Small and convenient , So it's a very good embedded database ,SQLite A lot of them are used in mobile phones ,PDA,MP3 Players and set top box devices .    Mozilla Firefox Use SQLit ...

  9. ( turn )Mysql Common command line

    original text :http://www.cnblogs.com/TsengYuen/archive/2012/01/11/2319034.html Mysql Common command line Mysql I often use the command to complete the book First step .my ...

Random recommendation

  1. Tomcat 6 --- Use Jasper Engine parsing JSP

    be familiar with JAVA web Development friends all know JSP Will be converted into java file ( precompile ), And compile it into class Use , Namely, in accordance with the JSP-->java-->class To compile . because JVM Know only class ...

  2. iOS Develop a collection of official documents

    The learning process of programmers is endless , There are many ways for programmers to learn . You can learn from the video tutorial , You can also use other people's code understand . But when we focus on developing a platform , For a API Use or function implementation is questionable , Usually, a simple test can make ...

  3. centos Lower installation mysql Cannot start

    The beginner made a mistake :yum install mysql The order is :yum -y install mysql-server, instead of yum -y install mysql ---------------------- following ...

  4. linux Order to practice once a day :find And rm To find and delete a directory or file

    linux Order to practice once a day linux in find And rm To find and delete a directory or file linux Next use find Command to find files ,rm Command to delete files . Delete the specified file in the specified directory find The name of the directory to look for -name .s ...

  5. Pressure DP Summary

    For more than a week DP, I get it a little bit , It can be divided into two kinds : The data is in the matrix , The data is linear , In the matrix is generally platoon of this kind of , There is also a linear structure in which the given conditions let you find the maximum weight , For example, finding the maximum weight path ,TSP Problems, etc. , ...

  6. Make it clear in a picture TCP flow control

  7. anki_vector SDK The source code parsing ( course )

    One : lately anki vector robot It's open Python SDK, The first time I heard it, I quickly checked it on the Internet , Let's throw some important links to the official website first : Python Programming API Manual and environment construction, etc : https://sdk-re ...

  8. Sql Server Database Constraints

    One . Classification of constraints Entity constraints : About the constraints on rows , For example, the value of one line is not allowed to appear in other lines , Such as primary key Domain constraints : About column constraints , Constrain certain columns of all rows in a table , Such as check constraint Refer to integrity constraints : If the value of a column has to be the same as the value of other columns ...

  9. Win10+Ubuntu18.04 UEFI Boot mode SSD+HDD

    Novice operation manual installation Ubuntu, There are so many puddles . Share a good experience :https://blog.csdn.net/xrinosvip/article/details/80428133( Attached below is the original blog ) Step on the pit and gather together : ...

  10. VBA Learning notes (8)-- Traverse all the folders and files

    explain (2017.3.26): 1. It's from the blue fantasy teaching video “ Father son transformation ” 2. such VBA It's very difficult to understand how to traverse a folder , Mainly because dir This function , The first call with parameters , The first file in this directory is returned , The first ...