mysql中建立联合主键

CREATE TABLE students (
    student_id INT,
    course_id INT,
    grade FLOAT,
    PRIMARY KEY (student_id, course_id)
);

CREATE TABLE students (
    student_id INT NOT NULL,
    course_id INT NOT NULL,
    grade FLOAT,
    PRIMARY KEY (student_id, course_id)
);

SELECT * FROM students WHERE student_id = 1 AND course_id = 101;

UPDATE students SET grade = 95 WHERE student_id = 1 AND course_id = 101;

-- 创建一个包含联合主键的表
CREATE TABLE students (
    student_id INT NOT NULL,
    course_id INT NOT NULL,
    grade FLOAT,
    PRIMARY KEY (student_id, course_id)
);

-- 插入数据
INSERT INTO students (student_id, course_id, grade) VALUES (1, 101, 85.5);
INSERT INTO students (student_id, course_id, grade) VALUES (2, 101, 90.0);

-- 查询数据
SELECT * FROM students WHERE student_id = 1 AND course_id = 101;

-- 更新数据
UPDATE students SET grade = 95 WHERE student_id = 1 AND course_id = 101;