answersLogoWhite

0


Best 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

User Avatar

Wiki User

15y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is a Trigger in MySQL Define different types of Trigger?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are the different types of databases available?

sql db2 oracle mysql


What are the 5 different types of databases?

Relational databases: Organize data into tables with rows and columns. NoSQL databases: Designed for large volumes of unstructured or semi-structured data. Object-oriented databases: Store data as objects. Graph databases: Optimal for data with complex relationships. In-memory databases: Data stored in RAM for faster access.


What are 5 different types of databases?

sql db2 oracle mysql


What are the different user define data typesexplain with example?

what are the different user define data types explain with example


Define the 2 different types of soilds?

Crystaline and Amorphous


How many data types supported by MySQL?

Data types supported by MySQL are date and time data, numeric data, and byte data. Spatial data is another type supported by MySQL which includes the use of spatial extensions.


Why crops are dependent on different types of soil?

Crops are dependent on different types of soil, because the acidity of the soil will define what crops can grow in it.


How do the types of music contribute in music?

how types of music contribute to music is it gives music different dinamics and varieties to make it sound interesting. mixing different types of music can make music more enjoyable and different. the different types of music define the creator of that music. how types of music contribute to music is it gives music different dinamics and varieties to make it sound interesting. mixing different types of music can make music more enjoyable and different. the different types of music define the creator of that music.


Name and define the two different types of stroke?

can anyone answer me what is the 2 names of 2 stroke engine and define its name or meaning..


What types of database programs are there?

MS Access, MySQL, SQL Server,


What are the different engines of MySQL?

There are many different types of storage engine for MySQL, aswell as many custom versions. The most common ones used are MyISAM and InnoDB.MyISAMFalconMergeMemory (heap)FederatedArchiveCSVBlackholeClusterBerkeley DBEXAMPLEMariaInnoDBsolidDBNitroEDBInfobright (formerly Brighthouse)KickfireXtraDBIBM DB2One thing about MySQL is that it allows you to use a mixture of these engines within the same database, so depending on the table you can use the engine type that suits it best for your needs.


How is typedef different from int in c language?

They are entirely different things; int is a type, typedef is a way to define types.