import mysql.connector # 创建数据库连接 db = mysql.connector.connect( host="localhost", user="root", password="password", database="grad_student_management" ) # 创建游标对象 cursor = db.cursor() # 创建students表 create_students_table = """ CREATE TABLE students ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, student_number VARCHAR(255) UNIQUE NOT NULL, major VARCHAR(255) NOT NULL ); """ # 创建grades表 create_grades_table = """ CREATE TABLE grades ( id INT AUTO_INCREMENT PRIMARY KEY, student_id INT, course_name VARCHAR(255), grade FLOAT, FOREIGN KEY (student_id) REFERENCES students(id) ); """ # 执行SQL语句 cursor.execute(create_students_table) cursor.execute(create_grades_table) # 关闭游标和数据库连接 cursor.close() db.close() ]]>
