• • 此问题在此处已有答案**：

sqlite3.Warning: You can only execute one statement at a time（5个答案）
3天前关闭。
运行此代码时出现错误

import sqlite3
conn = sqlite3.connect("Sqlite3 file path")
cursor = conn.cursor()

Name = "Test"
LastName = "Test"
Id = 2
Grade = 12

cursor.execute("""
    BEGIN TRANSACTION;

    INSERT INTO Students (FirstName,LastName) VALUES(?,?);
    
    INSERT INTO StudentsYears (StudentId,YearId,Grade) VALUES((SELECT LAST_INSERT_ROWID() from Students),?,?);
    
    END TRANSACTION;""" , (Name , LastName , Id , Grade))

conn.commit()

有什么问题？..............................