Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Programming > Database Programming > MySQL > What is a Trigger in MySQL Define different types of Trigger?

Other contributors have said "Define the role of a trigger point?" is the same question as "What is a Trigger in MySQL Define different types of Trigger?" If you believe that these are not asking the same thing and should be answered differently, click here

What is a Trigger in MySQL Define different types of Trigger?

In: MySQL [Edit categories]

Answer:

A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on values involved in an update.

A trigger is associated with a table and is defined to activate when an INSERT, DELETE, or UPDATE statement for the table executes. A trigger can be set to activate either before or after the triggering statement. For example, you can have a trigger activate before each row that is deleted from a table or after each row that is updated.

Sender : Yugant khokhar

First answer by ID2057452527. Last edit by Yugantk. Contributor trust: 0 [recommend contributor ]. Question popularity: 1 [recommend question].

[report abuse]

Can you answer these MySQL questions?

	What makes a database spatial?	Answer it!
	What is the difference between self join and Inner Join?	Answer it!
	What will be the entities of an airline database?	Answer it!
	What are the differences between Oracle and MySQL?	Answer it!
	What are the functions performed by the DBMS and DBA?	Answer it!

Relevant answers:

What are type of trigger?
static trigger dynamic trigger hold trigger
What types of things can trigger hives?
In addition, hives may also result from the body's response to certain physical conditions, such as emotional stress , rubbing, cold wind,
What type of triggers does a sniper use?
there isn't one answer here, it depends on the weapon and what the shooter is comfortable with, another thing to take into account is cost
What triggers type 1 diabetes?
Type 1 diabetes is an autoimmune disorder, which means the body's immune system mistakes it's own cells as a threat and attacks them. In people with type 1 diabetes the immune system attacks the...
What is trigger?
A trigger is defined for and connected to a RDBMS table. A trigger can be defined to do a particular job (typically insert audit records in another table or perform some validations) whenever the...