users表有字段 id,user_name,son_users表有id,user_id(user表主键),son_name;我想在删除user表一条记录时,son_user表关联删除一条记录
CREATE TRIGGER user_delete_view
AFTER DELETE ON users
FOR EACH ROW
BEGIN
delete from son_users where user_id=users.id;
END
CREATE TRIGGER user_delete_view
AFTER DELETE ON users
FOR EACH ROW
BEGIN
delete from son_users where user_id=users.id;
END
有2处调整下:
DELIMITER //
CREATE TRIGGER user_delete_view
AFTER DELETE ON users
FOR EACH ROW
BEGIN
DELETE FROM son_users u where u.user_id = OLD.id;
END;
//
DELIMITER ;