I am trying to create an INNODB table with a foreign key, and it doesnt seem to be working. Can someone give me an example on how to use a foreign key. Here is an example of what i have:
FOREIGN KEY (client_id) REFERENCES CLIENT (client_id)
This line is preventing me from creating the table. It works without this line. Someone please help me :sad:
