"Uzi Klein" <uzi@xxxxxxxx> wrote in message news:005901c427ed$526e76c0$f805a8c0@xxxxx > 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. Take a look here: http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
