mysql表联合主键 索引吗

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

CREATE INDEX idx_student_id ON students(student_id);

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

-- 创建一个包含联合主键的表
CREATE TABLE students (
    student_id INT,
    course_id INT,
    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 (1, 102, 90.0);
INSERT INTO students (student_id, course_id, grade) VALUES (2, 101, 78.5);

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