SQLite Database with Python: How to Create Tables, Insert Data, and Run Queries

Python has a built-in database called SQLite. In this tutorial, we'll learn how to create tables, insert data and run queries using Python.

--------------------
Content:
0:00 Intro
0:44 Connect to a database
1:41 Create tables
6:12 Insert data
11:43 Run queries

[rileyhampson]

Thanks so much! I already knew SQL from my time working with php and databases and just needed help using it in Python.

[marcosg]

thank you! It helped me a lot to clear up doubts, greetings from Argentina!

[hasanmougharbel]

Hey there,
God bless you efforts.
I am new to sql with a general enquiry.
Why using a cursor would make use of ram memory much more than views?
Aren't views produced in memory ram?
Thanks for taking care of my enquiry.

[EnRico_]

Thank you very much for this simple but very effective video. Your time and effort are very much appreciate here. Just a question if you don't mind: what is the advantage of using SQLite instead of just importing your data properly formatted and placed in a xlsx/txt/xml file? Anyway....thank you

[linustorvalds]

mycursor = conn.cursor()
mycursor.execute("""
SELECT * FROM MYFIRSTTABLE
""")
output = mycursor.fetchone()
print(output)
Will also do the trick an don't need to go to the site... just saying...