delimiter $
create trigger insert_trigger
after insert on noticetemp
for each row
begin
set notice.NoticeID = (select NoticeID from noticetemp);
set notice.Titile = (select NoticeTitle from noticetemp);
set notice.Editor = (select Editor from noticetemp);
set notice.NoticeDate = (select NoticeDate from noticetemp);
set noticedetail.NoticeID = (select NoticeID from noticetemp);
set noticedetail.NoticeText = (select NoticeText from noticetemp);
set noticeindex.ClassID = (select Class from noticetemp);
set noticeindex.NoticeID = (select NoticeID from noticetemp);
delete from noticetemp;
end$
delimiter ;
运行后提示 Error Code: 1193. Unknown system variable 'NoticeID'
新手求指导
MySQL中的Unknown system variable
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-