执行以下代码,数据表中共有几条数据?( )

kv794370 单选题 共 个子题
import sqlite3

conn = sqlite3.connect('student_info.db')

cursor = conn.cursor()

cursor.execute('''CREATE TABLE IF NOT EXISTS Student

(id INTEGER PRIMARY KEY, name TEXT, age INTEGER)''')

cursor.execute("INSERT INTO Student (id, name, age) VALUES (1, 'Alice', 20)")

cursor.execute("INSERT INTO Student (id, name, age) VALUES (2, 'Bob', 2)")

cursor.execute("INSERT INTO Student (id, name, age) VALUES (3, 'Charlie', 21)")

cursor.execute("SELECT * FROM Student")

students = cursor.fetchall()

for student in students:
print(f"ID: {student[0]}, Name: {student[1]}, Age: {student[2]}")

cursor.execute("UPDATE Student SET age = 23 WHERE id = 2")

cursor.execute("DELETE FROM Student WHERE id = 3")

conn.commit()

conn.close()

A

2

B

3

C

4

D

5

正在加载题目数据…
已答 /
子题
该题型需在试卷/作业中作答,单题练习暂不支持
答案解析
讨论
发布
登录后参与讨论 立即登录
发布讨论需先绑定并验证手机号 去绑定手机号
加载中…
我
我
回复 @
回复 @
发送
还没有人讨论,来发表第一条吧