import mysql.connector
# 连接MySQL数据库
conn = mysql.connector.connect(
host="localhost",
user="your_username",
password="your_password",
database="StudentDB"
)
# 创建游标对象
cursor = conn.cursor()
# 3. 向Student表中添加一条记录
insert_query = "INSERT INTO Student (name, birth_year) VALUES (%s, %s)"
student_data = ("Your Name", 2000) # 请将 "Your Name" 替换为实际的名字
cursor.execute(insert_query, student_data)
conn.commit()
print("添加记录成功!")
# 4. 修改表中出生年月为2012年的学生为2022年
update_query = "UPDATE Student SET birth_year = 2022 WHERE birth_year = 2012"
cursor.execute(update_query)
conn.commit()
print("修改记录成功!")
# 5. 删除表中第一条记录
delete_query = "DELETE FROM Student LIMIT 1"
cursor.execute(delete_query)
conn.commit()
print("删除记录成功!")
# 关闭连接
cursor.close()
conn.close()