SQLite Learning Note 2: Creating a Database

In the last note, a sqlite executable was generated, and the CD is executed under the directory where SQLite is located:

Sqlite3 mydatabase.db

A database called mydatabase.db is created, and a file called Mydatabase.db is generated below the current path.

#切记不是先运行sqlite3, and then the above command, but the terminal directly enter the above command, otherwise it will error: Error:near "sqlite3": Syntax Error

Then run the command:

. databases

To view the database you just created, exit the database command line using the following command:

. Quit

You can also use the command:

. Help

View Help