测评会员优惠活动进行中 · 开通 VIP,有效期内测评不限次 VIP 优惠中 · 测评不限次 立即查看

A32419. 运行以下代码输出的数据为? ( ) import sqlite3connection=sqlite3.connect("students.db")cursor=connection.cursor()cursor.execute("CREATE TABLE students(name TEXT,age INTEGER)")cursor.execute("INSERT INTO students V…

单选题 困难

题目描述

运行以下代码输出的数据为? (    ) 

import sqlite3

connection=sqlite3.connect("students.db")

cursor=connection.cursor()

cursor.execute("CREATE TABLE students(name TEXT,age INTEGER)")

cursor.execute("INSERT INTO students VALUES(John',19)")

cursor.execute("INSERT INTO students VALUES('John',18)")

cursor.execute("DELETE FROM students WHERE name='John'")

cursor.execute("INSERT INTO students VALUES('John',17)")

cursor.execute("UPDATE students SET age=22 WHERE name='John"')

cursor.execute("SELECT*FROM students")

results=cursor.fetchall()

for row in results:

    print(row)

connection.close()

选项(单选)

上一题 下一题