插一行再插两行,一共几行
查完还是原样,改完回不去
查过
改过
先插一行,再一次插两行。输出三个数:第一次改了几行、第二次改了几行、现在表里一共几行(用 / 隔开)。
import sqlite3
db = sqlite3.connect(":memory:")
db.execute("""CREATE TABLE goods (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL UNIQUE,
cat TEXT NOT NULL,
price INTEGER NOT NULL,
stock INTEGER)""")
db.executemany("INSERT INTO goods VALUES (?,?,?,?,?)", [
(1, "绿茶", "饮料", 6, 12), (2, "红茶", "饮料", 6, 0),
(3, "苏打水", "饮料", 5, None), (4, "薯片", "零食", 8, 7),
(5, "海苔", "零食", 12, 3), (6, "巧克力", "零食", 15, None),
(7, "铅笔", "文具", 2, 40), (8, "笔记本", "文具", 9, 5),
(9, "橡皮", "文具", 3, 0), (10, "冰红茶", "饮料", 4, 20)])
a = db.execute("INSERT INTO goods VALUES (11,'话梅','零食',7,4)")
b = db.executemany("INSERT INTO goods VALUES (?,?,?,?,?)",
[(12, "果冻", "零食", 3, 9), (13, "橙汁", "饮料", 7, 6)])
n = db.execute("SELECT COUNT(*) FROM goods").fetchone()[0]
print(str(a.rowcount) + "/" + str(b.rowcount) + "/" + str(n))
全部评论