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
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
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