class 15 ||mysql tuterials|| triggers|| create trigger|| show trigger || update trigger скачать в хорошем качестве

class 15 ||mysql tuterials|| triggers|| create trigger|| show trigger || update trigger

topic ====== MySQL triggers ===================================================================================================================================================================================================== MySQL triggers: ================ in MySQL trigger is defined as that some event id occurred in the existing table is called triggers, =some times MySQL triggers we called stored processor. =just like we are using triggers it will show update/delete/insert return create trigger ============== we are using triger having with 3 conditionsor events and two times where time: ====== "before/after" event: ========= "insert/update/delete" syntax: ======= create trigger trigger name time event on existing table for each row begin ..... end; create trigger ============== now we create trigger where the table name is student1 through the help of existing like student =name,age,score delimiter// create trigger student1 before insert on student for each row begin if new.score less than 0 then set new.score=0; end if; end;// delimiter; 2 show : ======= syntax: ======= show trigger name; 3 drop trigger ============ syntax: ========== drop trigger name;