python中关于executemany以及序列的实例详解

import sqlite3

persons=[

  ("Jim","Green"),

  ("Hu","jie")

  ]

conn=sqlite3.connect(":memory:")

conn.execute("CREATE TABLE person(firstname,lastname)")

conn.executemany("INSERT INTO person(firstname,lastname) VALUES(?,?)",persons)

for row in conn.execute("SELECT firstname,lastname FROM person"):

  print(row)

print("I just deleted",conn.execute("DELETE FROM person").rowcount,"rows")