Skip to content

B7-9414/database-

Repository files navigation

===================================================================================

installation (ubuntu):

sudo apt-get install sqlitebro sudo apt install sqlite3 (using terminal)

===================================================================================

installation (windows):

Download DB browser: https://sqlitebrowser.org/ Download sqlite: https://www.sqlite.org/download.html (using sqlite3.exe) visit for more information about installation: https://www.youtube.com/watch?v=U7nfe4adDw8

==================================================================================

Basic commands that you need (sqlite3): to creat table: sqlite3 Database CREATE TABLE company(name TEXT, age INT); INSERT INTO company(name,age) INSERT INTO pll(Bassam,25);

.table // dispaly the tables .schema // display the schema

select * from company; // Basic Syntax to display database

.quit // stop using sqlite

** also you can open it with DB browser to see the database

===================================================================================

Python : create_table() // make sure that after you create the table mark it as comment Insert_data() // make sure that after you insert the data mark it as comment read_from_db() // read the data after creatd the table and inserted the data

** after you running the program, it should create a file called Database_py3.db open the Database_py3.db file with DB browesr or using sqlite3

===================================================================================

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages