Translating a One-to-One Relationship to SQL

Giovanni Pace

Description

I'll show you how to translate a One-to-One relationship to SQL in MySQL. We'll create the secondary table with a foreign key pointing to the main table and add a UNIQUE constraint on that column to ensure each record can be linked to only one record in the other table.