Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. import sqlite3
  2. co = sqlite3.connect('db.db')
  3. with open('sql.sql') as f:
  4. data = f.read()
  5. commands = data.split(';')
  6. for query in commands:
  7. co.execute(query)
  8. c = co.cursor()
  9. c.execute("SELECT * FROM table")
  10.  
  11. rows = c.fetchall()
  12.  
  13. for row in rows:
  14. print(row)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement