Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3
- co = sqlite3.connect('db.db')
- with open('sql.sql') as f:
- data = f.read()
- commands = data.split(';')
- for query in commands:
- co.execute(query)
- c = co.cursor()
- c.execute("SELECT * FROM table")
- rows = c.fetchall()
- for row in rows:
- print(row)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement