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 ...
CREATE TABLE IF NOT EXISTS `mydb`.`errors_reports` ( `error_id` INT NOT NULL , `report_short` VARCHAR(15) NOT NULL , PRIMARY KEY (`error_id`, `report_short`) , INDEX `error_id_idx` (`error_id` ASC) , INDEX `report_short_idx` (`report_short` ASC) , ...