Python SQLite CRUD – Create Table, Insert, Update, Delete, Where Clause, Conditionals, limiting data.

n this video, I demonstrated how to create a SQLite database using Python and perform CRUD operations.

Git Repo: https://github.com/hydrogeologist/python-sqlite

create database and connection

import sqlite3
conn = sqlite3.connect(‘tutorialcustomer.db’)

create a table

cursor.execute(“””CREATE TABLE customers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
first_name TEXT NOT NULL,
last_name TEXT NOT NULL,
email TEXT
)
“””
)

create a table

cursor.execute(“””CREATE TABLE customers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
first_name TEXT NOT NULL,
last_name TEXT NOT NULL,
email TEXT
)
“””
)

Select data from a table

cursor.execute(“SELECT * from customers”)

Select data from a table

cursor.execute(“SELECT * from customers where last_name=”Basu”)
cursor.execute(“SELECT * from customers where email like (‘%gmail%’)”)

order data

cursor.execute(“””
SELECT * from customers where email like (‘%gmail%’)
ORDER BY first_name desc
“””)

conditionals

cursor.execute(“””
SELECT * from customers where email like (‘%gmail%’)
AND id = 5
ORDER BY first_name desc
“””)
for row in cursor.fetchall():
#print(row)
print(row[1] +” ” + row[2] + ” ” + row[3])

Update data into a table

cursor.execute(“””
UPDATE customers
SET first_name=”UpdatedAnkan”
WHERE id=1
“””
)

Delete data from a table

cursor.execute(“””
DELETE from customers
WHERE id=10
“””
)

 1,595 total views,  4 views today