Alternate Key
Learn Alternate Key (Keys, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction An alternate key is a candidate key that was not chosen as the primary key. It still identifies a row uniquely, so in MySQL you declare it as UNIQUE (and normally NOT NULL ).