想写一条触发器语句如下:
create trigger Sdept_delete
after delete on Sdept for each row
begin
delete from stu_info where Sid like '____'+old.Sid+'____';
end
报错,正确的写法应该是什么样的?请各位大牛帮帮忙!
create trigger Sdept_delete
after delete on Sdept for each row
begin
delete from stu_info where Sid like '____'+old.Sid+'____';
end
报错,正确的写法应该是什么样的?请各位大牛帮帮忙!
set @sql =concat('delete from stu_info where Sid like ','"____',old.Sid,'____"');
PREPARE stmt2 FROM @s;
execute stmt2;
end
after delete on Sdept for each row
begin
delete from User where Uname=old.Sid;
set @sql =concat('____',old.Sid,'____');
delete from stu_info where Sid like @sql;
end