在Python中创建了SQLite数据库和数据表,如下图所示:
import sqlite3 conn=sqlite3.connect('d:/fruit.db') cur=conn.cursor() conn.execute("INSERT INTO fruit VALUES('桔子',4.5)") conn.execute("INSERT INTO fruit VALUES('葡萄',2.5)") conn.commit() conn.execute("DELETE FROM fruit WHERE price=2.5") conn.commit() cur.execute('SELECT * FROM fruit') conn.close()
执行完上述代码后,数据表中还剩下多少条数据?( )
6
5
4
3