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

preview_player
Показать описание
purchase these products from amazon at cheap prices
________________________________________________________________________________
#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.
import sqlite3
Once a Connection has been established, create a Cursor object and call its execute() method to perform SQL commands:

# Create table
(date text, trans text, symbol text, qty real, price real)''')

# Insert a row of data

# Save (commit) the changes

# 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.
_______________________________

#Code_With_Tuqi
Please Guys, like and subscribe to my channel!!
Рекомендации по теме