Small problems consult a trigger

There are two tables
Result and record table




Record once the insert operations, will automatically update all records in result result_point
The result_point values in the corresponding ID record the number of records in a table

Triggers should be how to write? Or data should be how to find? I found the synchronous table two~
Thank you

Started by Barbara at November 21, 2016 - 8:17 PM

create trigger tri_record_insert before insert on record for each row
begin
update result set result_point=(select count(*) from record where recod_markid=new.id)
where redult_id=new.id;
end

Posted by Lance at November 27, 2016 - 8:34 PM

Why not use after insert on record?

Posted by Barbara at December 08, 2016 - 8:41 PM