CREATE TABLE students (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50) NOT NULL,
grade INT,
major VARCHAR(100)
);
对于`teachers`表来说，类似地这样写：
CREATE TABLE teachers (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50) NOT NULL,
department VARCHAR(100),
position VARCHAR(50)
);
INSERT INTO students (name, grade, major) VALUES ('Alice Smith', 10, 'Computer Science');
同样的方法也可以用于`teachers`表。
SELECT name FROM students;
这样就能列出所有学生的名字了。
import mysql.connector
db = mysql.connector.connect(
host="localhost",
user="root",
password="password",
database="school_management"
)
cursor = db.cursor()
def add_student(name, grade, major):
sql = "INSERT INTO students (name, grade, major) VALUES (%s, %s, %s)"
val = (name, grade, major)
cursor.execute(sql, val)
db.commit()
print(cursor.rowcount, "record inserted.")
# 示例调用
add_student('John Doe', 11, 'Mathematics')
本站部分内容及素材来源于互联网，由AI智能生成，如有侵权或言论不当，联系必删！
