Re: AFTER Delete Trigger question
As far as I know, you can´t change data on the same table in triggers. Kevin Labecot ke...@labecot.fr escreveu na mensagem news:4d2ce38b-d169-478b-aebf-c19f20dce...@labecot.fr... Hi, Is there a way to update the same table on a delete trigger ? I need to call an UPDATE statement when a delete occurs. Best regards -- Kevin Labecot, Innovantic www.innovantic.fr Tél. : 05.56.45.60.54
Foreign keys
Hello everybody. I'm using php 4.4 and mysql 5.0 and i'm having the bellow issue: I've a group table and a system table, bellow this i have a group_system table that has a foreign key to group table and to system table. When a tried to delete one register in the group_system table, it gives me the bellow error: Cannot add or update a child row: a foreign key constraint fails (`buffets/group_system`, CONSTRAINT `fk_group_group_sistema` FOREIGN KEY (`idgrp`) REFERENCES `group` (`idgrp`) ON DELETE CASCADE ON Anyone knows to tell me wath's happening here? Thanks for all tips. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]