如何为MS编写this触发器?
MySql版本:
CREATE TRIGGER log_patron_delete AFTER DELETE on patrons
FOR EACH ROW
BEGIN
DELETE FROM patron_info
WHERE patron_info.pid = old.id;
ENDSql server版本:
CREATE TRIGGER log_patron_delete ON patrons AFTER DELETE
AS
BEGIN
DELETE FROM patron_info WHERE patron_info.pid = old.id;
END问题:old.id适用于MySql,但不适用于MySql
发布于 2016-04-13 15:57:33
这不是触发器的作业,而是外键约束的作业。您应该在patrons表和patron_info表之间创建一个外键,并使用选项delete cascade创建它。
ALTER TABLE patron_info
ADD CONSTRAINT FK_patron_info_patrons FOREIGN KEY (pid)
REFERENCES patrons(id)
ON DELETE CASCADE这样,您就不能在patron_info中有与赞助人表无关的任何行,并且一旦从赞助者表中删除一行,patron_info中的相应行就会自动删除。
https://stackoverflow.com/questions/36601486
复制相似问题