加不加那一个等号,差几行
把两条只差一个等号的查询各跑一次,输出两个行数(用 / 隔开)。
import sqlite3
db = sqlite3.connect(":memory:")
db.execute("CREATE TABLE goods (id INTEGER, name TEXT, cat TEXT, price INTEGER, 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("SELECT * FROM goods WHERE price > 6").fetchall()
b = db.execute("SELECT * FROM goods WHERE price >= 6").fetchall()
print(str(len(a)) + "/" + str(len(b)))
全部评论