Learn to connect to SQLite from Command Line

The article describes how to use the sqlite3 tool to connect to SQLite from the command line. You may use the sqlite3 application to quickly and easily access the SQLite database directly.

# Steps to connect to SQLite3 using the command line :

1. Using SSH, log in to your Hostvento hosting account.

2. Type the following command, in your command line section. Replace example.db with the name of the database file that you want to use.

sqlite3 example.db

Note: You can use anything for a database file name, as per your wish. In case the database file doesn’t exist, SQL will create it. Whereas, if a database file already exists, SQLite opens the database contained in the file.

3. Once you access a database, you can then use regular SQL statements to run queries, create tables, insert data and more. Also,

(i) Type the following command at the sqlite> prompt, for SQLite show tables :

.tables

(ii) Type the following command at the sqlite> prompt, in-order to view the structure of a table. In this case, replace table with the name of the table that you want to view:

.schema table

(iii) Type .help at the sqlite> prompt, in-order to view a complete list of sqlite3 commands.

(iv) Type .quit at the sqlite> prompt, in-order to exit the sqlite3 program.

Get Information :

To view all the information regarding the sqlite3 program from the command line, type the following command :

man sqlite3

Also, to view the SQLite online documentation for the sqlite3 program, visit

https://www.sqlite.org/cli.html