What are triggers in Mysql?

68 Views

What are triggers in Mysql?

Trigger

Trigger can be define as a database object just like a stored procedure. It is a set of actions which fires automatically when an event occure in a database.

 

Triggers are, in fact, written to be executed in response to any of the following events −

  • A database manipulation (DML) statement (DELETE, INSERT, or UPDATE)
  • A database definition (DDL) statement (CREATE, ALTER, or DROP).
  • A database operation (SERVERERROR, LOGON, LOGOFF, STARTUP, or SHUTDOWN).
 create trigger insert_emp_status  
on emp  
after insert  
as  
begin  
insert into empstatus values('active')  
end 

 

Tags:-
MySQL

Today spacial posts