SQLite3 Database With Python-Creating a Database, Table, and Running Queries

purchase these products from amazon at cheap prices
Acer Swift 3 Thin & Light Laptop-https://amzn.to/3qbFKyf
Lenovo IdeaPad 3 Laptop-https://amzn.to/34LkfNh
cell phones and accessories-https://amzn.to/3tXgRYi
SanDisk 128GB microSDXC-Card-https://amzn.to/3icv12h
video editor monitors-https://amzn.to/3wbfQ1v
SAMSUNG Galaxy Buds Live True Wireless Earbuds -https://amzn.to/3th1Od1
________________________________________________________________________________
#SQLite is a C library that provides a lightweight disk-based database that doesn’t require a separate server process and allows accessing the database using a nonstandard variant of the #SQL query language. Some applications can use SQLite for internal data storage. It’s also possible to prototype an application using SQLite and then port the code to a larger database such as PostgreSQL or Oracle.
To use the module, start by creating a Connection object that represents the database. Here the data will be stored in the example.db file:
import sqlite3
con = sqlite3.connect('example.db')
Once a Connection has been established, create a Cursor object and call its execute() method to perform SQL commands:
cur = con.cursor()

# Create table
cur.execute('''CREATE TABLE stocks
(date text, trans text, symbol text, qty real, price real)''')

# Insert a row of data
cur.execute("INSERT INTO stocks VALUES ('2006-01-05','BUY','RHAT',100,35.14)")

# Save (commit) the changes
con.commit()

# We can also close the connection if we are done with it.
# Just be sure any changes have been committed or they will be lost.
con.close()
_______________________________


#Code_With_Tuqi
Entire Videos-https://www.youtube.com/c/codewithtuqiprogramming/videos
Please Guys, like and subscribe to my channel!!