The examinee_id column should be designated as PRIMARY KEY.

A NOT NULL qualifier should be moved from exam-id to examinee-id.

The PRIMARY KEY should be dropped and re-created as PRIMARY KEY (examinee-id, exam_id).

A NOT NULL qualifier should be added to examinee_id.

SHOW WARNINGS

GET DIAGNOSTICS CONDITION 1 @errno=MYSQL_ERRNO, @msg =MESSAGE_TEXT;

SELECT @errno, @msg;

SELECT ERRNO, MESSAGE_TEXT FROM INFORMATION_SCHEMA.DIAGNOSTICS_AREA WHERE CONDITION=1

SHOW GLOBAL STATUS LIKE ‘Diagnostics’

SELECT DISTINCT last_name, first_name FROM people

SELECT 1,2 FROM people GROUP BY last_name

SELECT first_name, last _name FROM people WHERE age LIKE ‘2’

SELECT 1, 2 FROM people WHERE last _name =’smith’

SELECT first _name, last_name FROM people LIMIT 1, 2