在删除xs时,把xscj中对应的记录删除
DELIMITER $$
CREATE
TRIGGER xs_delete AFTER DELETE
ON `xs`
FOR EACH ROW BEGIN
DELETE FROM `xscj` WHERE xh = old.xh;
END$$
DELIMITER ;
在删除xs时,把xscj中对应的记录删除
DELIMITER $$
CREATE
TRIGGER xs_delete AFTER DELETE
ON `xs`
FOR EACH ROW BEGIN
DELETE FROM `xscj` WHERE xh = old.xh;
END$$
DELIMITER ;