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/
_________________________________________________________________________________________
Wednesday, February 16, 2022
Deploy SQLite Browser in Ubuntu 20.04 ( DB Browser For SQLite )
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment