books.py
import sqlite3 db = sqlite3.connect('bookshop.db') result = db.cursor().execute("SELECT * FROM books").fetchall() db.close()
import sqlite3 db = sqlite3.connect('bookshop.db') result = db.cursor().execute("SELECT * FROM books").fetchall() db.close() print(result)
import sqlite3 db = sqlite3.connect('bookshop.db') result = db.cursor().execute("SELECT * FROM books").fetchall() db.close() print(result[0]) #shows tuple number 0
import sqlite3 db = sqlite3.connect('bookshop.db') result = db.cursor().execute("SELECT * FROM books").fetchall() db.close() print(result[0]) print(result[1])
Core Activities:
result
list?Extension Activities:
result
in the above code is a list of tuples, as is the case here:result = [("a","b","c"),("d","e","f")]
print(result[0])
('d', 'e', 'f')
to the console window.