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.
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
Also Read :
