Tech
Infected

Linux, OpenSource, Programming And Hacks

Jan 14, 2018

How to Install SQLite3 in Ubuntu / Linux Mint

Jan 14, 2018
SQlite is an Embedded Relational Database Management System. SQlite does not require a server to run unlike mysql or other popular dbms.


To install Sqlite3 in Ubuntu / Linux Mint issue the following commands

This will work for Ubuntu 14.04 and above

sudo apt-get update
sudo apt-get install sqlite3 libsqlite3-dev



Basic Command Line Usage:

1. Create a new Database

aman@vostro:~$ sqlite3 databasename.db
SQLite version 3.11.0 2016-02-15 17:29:24
Enter ".help" for usage hints.
sqlite>  
 

2. Create a table and insert values in it.
sqlite> CREATE TABLE student (id integer, firstname varchar(30), lastname varchar(20), country varchar(20));
sqlite> INSERT INTO STUDENT VALUES (1, "James", "Hetfield", "USA");
sqlite> INSERT INTO STUDENT VALUES (2, "Kirk", "Hammet", "USA");


3. View all table entries
sqlite> select * from student;
1|James|Hetfield|USA
2|Kirk|Hammet|USA


4. Exit Sqlite3
sqlite> .exit

5. Open Existing Database
aman@vostro:~$ sqlite3 databasename.db



No comments:

Post a Comment