CREATE TABLE IF NOT EXISTS `mydb`.`language` ( `idlangues` TINYINT UNSIGNED NOT NULL , `Language_Name` VARCHAR(10) NOT NULL , PRIMARY KEY (`idlangues`) ) ENGINE = InnoDB; -- --- -- Table `mydb`.`Accomodation` -- --- DROP TABLE IF EXISTS `mydb`....
Here's the trigger code (which loads to the database without error): DELIMITER // CREATE TRIGGER mydb.ctct_del AFTER DELETE ON mydb.contact FOR EACH ROW BEGIN if exists (select contact.id_ctct from mydb.contact where old.id_ctct = contact.id_ctct_rltd) then ...