Wednesday, February 16, 2022

Deploy SQLite Browser in Ubuntu 20.04 ( DB Browser For SQLite )

 in This Tutorial you will learn "How To install SQLite And SQLite Browser ( DB Browser for SQLite ) in Ubuntu 20.04 "

DB Browser for SQlite is an open source . freeware visual tool used to create, design and edit SQlite database files.
Homepage - https://sqlitebrowser.org/  | Github - https://github.com/sqlitebrowser/sqlitebrowser
_________________________________________________________________________________________
Server - Os:  Ubuntu 20.04.3 LTS 64Bit        | IP -192.168.1.80            |Hostname -  ubuntu.example.com
_________________________________________________________________________________________
lsb_release -d ; apt install sqlite3 sqlitebrowser -y
sqlite3 testdb
.databases

Make a Table in SQLite -
CREATE TABLE test_student(
name String,
age Int
);

.tables

Inserting Data Into a Table in SQLite -

INSERT INTO test_student(name, age)
VALUES ('John', 16),
('Bob', 18),
('Ivan', 14);

View a Table Data in SQLite - SELECT * FROM test_student;
cp testdb /home/ubuntu/Downloads/
_________________________________________________________________________________________

No comments:

Post a Comment