SHOW TABLE STATUS FROM yourdatabasename LIKE 'departments' which will show us the constraints for table departments..-Martin----- Original Message ----- From: "Daniel Rossi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 5:50 PM Subject: Constraint Symbol
What is the definition of the constraint symbol there is no example of it in the docs ? Also on a few tables i get errors trying to setup foreign keys ALTER TABLE departments ADD FOREIGN KEY (departmentID) REFERENCES departments_join(departmentID) ON UPDATE CASCADE this for example gives me Cannot add or update a child row: a foreign key constraint fails Any ideas ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
