CREATE TRIGGER `autodelete_Person_rst` AFTER DELETE ON `Person` BEGIN DECLARE @caId INT ; SELECT @caId=id FROM Person; DELETE FROM Photographer WHERE id=@caId; END 随手写了一个,你可以验证一下,如若不行,可以稍作修改
InnoDB是引擎,如果不是InnoDB表用TRIGGER解决DELETE FROM Photographer WHERE id=old.id;
BEGIN
DECLARE @caId INT ;
SELECT @caId=id FROM Person;
DELETE FROM Photographer WHERE id=@caId;
END
随手写了一个,你可以验证一下,如若不行,可以稍作修改
innodb是个存储引擎。