Staging
v0.5.1
https://github.com/python/cpython
Raw File
Tip revision: 69c0db5050f623e8895b72dfe970392b1f9a0e2e authored by Ned Deily on 21 March 2017, 06:32:38 UTC
Update docs and patchlevel for 3.6.1 final
Tip revision: 69c0db5
insert_more_people.py
import sqlite3

con = sqlite3.connect("mydb")

cur = con.cursor()

newPeople = (
    ('Lebed'       , 53),
    ('Zhirinovsky' , 57),
  )

for person in newPeople:
    cur.execute("insert into people (name_last, age) values (?, ?)", person)

# The changes will not be saved unless the transaction is committed explicitly:
con.commit()
back to top