mySQL foreign keys

Expand Post »

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

Similar Threads

Lots of Foreign keys...locking? in MySQL
insert into multiple tables linked by foreign keys (PHP, MySQL) in PHP
SQL statement to count foreign keys in MySQL
PHP Dynamic Forms in PHP
Foreign keys from one table to a parent field in Database Design

csc Mindy

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Aug 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: libmysqld

Next Thread in MySQL Forum Timeline: MySQL nested query / joined query conversion help

DaniWeb Message

Cancel Changes

User Name
Password