blob: edbc79e7e5b6cce21286fcbb2c640565c35cf1d5 (
plain)
| 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 | 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()
 |