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
8) Output the table structure , At the same time, the index will output
.dump Table name
9) sign out
>.exit perhaps .quit
- 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 ...
- 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 ...
- 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 ...
- 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 *. ...
- 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. ...
- 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 ...
- 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 ...
- 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 ...
- ( 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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. , ...
- Make it clear in a picture TCP flow control
- 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 ...
- 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 ...
- 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 : ...
- 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 ...