I'm creating a database with multiple tables that are linked via unique IDs. Each table has a unique ID. My question is, when creating the tables in MySQL, how do I refer to the other table's unique ID? For example...here is the sql code for the table 'employees':
CREATE TABLE employees (
employee_id int(4)
unsigned
zerofill
DEFAULT '0000'
NOT NULL
auto_increment,
employee_name varchar(50),
employee_email varchar(50),
employee_position varchar(50),
...now I right here I want to refer/link to the table "duties" via that table's unique ID(dutyid). I'm not really sure how to do this...
any help?
Thanks,
Chris
CREATE TABLE employees (
employee_id int(4)
unsigned
zerofill
DEFAULT '0000'
NOT NULL
auto_increment,
employee_name varchar(50),
employee_email varchar(50),
employee_position varchar(50),
...now I right here I want to refer/link to the table "duties" via that table's unique ID(dutyid). I'm not really sure how to do this...
any help?
Thanks,
Chris