改正这段代码create TRIGGER insert_student before INSERT on student for each row begin insert from student_log where SID=id ; insert from student_log where SNAME=sname ; insert from student_log where SAGE=sage; end;

改正后的代码如下：

CREATE TRIGGER insert_student
BEFORE INSERT ON student
FOR EACH ROW
BEGIN
INSERT INTO student_log (SID, SNAME, SAGE) VALUES (NEW.id, NEW.sname, NEW.sage);
END;

注：NEW 表示插入操作中新插入的行的值。这里的代码将插入的学生信息同时插入到 student_log 表中的对应列中。