mysql foreign key syntax / tutorial

From: Date: Wed, 21 Apr 2004 22:09:31 +0000
Subject: mysql foreign key syntax / tutorial
Groups: php.db 
Request: Send a blank email to php-db+get-34026@lists.php.net to get a copy of this message
Hi. Any body got an idea how to use hte foreign keys in mysql innodb tables and how whould the change affect the performance of the server? lets say i have Items table, Clients table, and Sales table the Sales table always stores ClientID and ItemID but not every client/item is there a sale can be deleted without harming the client nor the item. i guess (not sure at all) it should go like : ALTER TABLE Sales ADD FOREIGN KEY ClientID(ClientID) REFERENCES Clients(ClientID) ON DELETE RESTRICT; ALTER TABLE Sales ADD FOREIGN KEY ItemID(ItemID) REFERENCES Items(ItemID) ON DELETE RESTRICT; Am I correct? thanks.

« previous php.db (#34026) next »