Skip to main content

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 ).

More lessons in Keys