Knowledge Base
MilesWeb / How-Tos

Learn to connect to SQLite from Command Line

Approx. read time : 2 min

The article explains how you can connect to SQLite from the command line using the sqlite3 program. To access the SQLite database directly in a quick and easy way, you may use the sqlite3 program.

# Steps to connect to SQLite3 using the command line :

1. Using SSH, log in to your MilesWeb 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.

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 :

(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:

(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 :

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

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

Also Read :

How can I connect to SQLite using Python?

How can I connect to SQLite using PHP?

Sonam Wagh
With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.