MySQL中的Unknown system variable

Question

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'
新手求指导

Answer 1

notice是什么，是表么？有没有NoticeID
noticetemp里有没有NoticeID