Using a database University create a trigger that generates

Using a database \"University\", create a trigger that generates a row for each student to a temporary table with the necesary infomration, if the average of the grades of the student in a semester is D or less.(MySQL)

Solution

create trigger cal_trig
before insert
on student
begin
If inserting then
:new.tot := :new.mtt1 + :new.mtt2;
end if;
end cal_trig;