I worked out the problem, it worked if i emptied the table, what could that be all about ?
>>> Daniel Rossi <[EMAIL PROTECTED]> 09/05/03 10:50am >>> 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]