MySQL触发器

DELIMITER $$


USE `cncdatabase`$$


DROP TRIGGER /*!50032 IF EXISTS */ `machinedelete`$$


CREATE
    /*!50017 DEFINER = 'root'@'localhost' */
    TRIGGER `machinedelete` AFTER DELETE ON `cnc_machine` 
    FOR EACH ROW BEGIN
DELETE FROM cnc_faultrecord WHERE recmachineno=old.idnum;
DELETE FROM cnc_machinecenter WHERE machineno=old.idnum;
DELETE FROM cnc_machinegrinder WHERE machineno=old.idnum;
DELETE FROM cnc_machinetool WHERE machineno=old.idnum;
DELETE FROM cnc_operation WHERE machineno=old.idnum;
    END;
$$


DELIMITER ;