Implementation of External table key triggers

The implementation of its own table foreign key trigger currently encounters such a foreign key definition: 't_ gir '. 'tb1 'straint' fk _ 1 'foreign key ('R _ id') REFERENCES 'tb1' ('id ') on delete cascade aims to restrict another field of the table. In this case, CASCADE deletion is unnecessary because it is for the same record of the same table. /* Trigger structure for table 'tb1 '*/DELIMITER $ /*! 50003 drop trigger *//*! 50032 if exists *//*! 50003 'tr _ tb1_before_insert '*/$ www.2cto.com /*! 50003 CREATE *//*! 50017 DEFINER = 'root' @ 'localhost '*//*! 50003 TRIGGER 'tr _ tb1_before_insert 'before insert on 'tb1 'for each row begin set new. r_id = new. id; END */$ DELIMITER; other engines except INNODB can be directly implemented using triggers. Author: yueliangdao0608