DROP PROCEDURE [IF EXISTS] _;
, , , if exists.
, .
, , :
insert ;
delete ;
Update .
:
CREATE TRIGGER trigger_name trigger_time trigger_event
ON tbl_name FOR EACH ROW trigger_stmt;
trigger_name, tbl_name. . trigger_time :
before ;
after .
trigger_event , , :
insert ;
update ;
delete .
tbl_name trigger_event trigger_time. , .
trigger_stmt , trigger_event tbl_name.
, begin... end. , . begin... end :
begin... end;
(if, case, while, loop, repeat, leave, iterate);
, , , , . new old . total, old.total, new.total.
DROP TRIGGER trigger_name;