Hi there,
I am trying to create tables in mysql and I obviously want to create relationships between the different tables...is there a syntax for foreign keys?
eg
would this work???
CREATE TABLE CUSTOMER(
.
.
.
Primary Key (Customer_ID),
Foreign Key (Reservation_ID));
Thanks in advance
Audrey
I am trying to create tables in mysql and I obviously want to create relationships between the different tables...is there a syntax for foreign keys?
eg
would this work???
CREATE TABLE CUSTOMER(
.
.
.
Primary Key (Customer_ID),
Foreign Key (Reservation_ID));
Thanks in advance
Audrey