How to create triggers in MySQL?



How to create triggers in MySQL?..

Answer / hrindows@gmail.com

We can use the CREATE TRIGGER statement for creating a new trigger in MySQL.

SYNTAX:
CREATE TRIGGER trigger_name
(AFTER | BEFORE) (INSERT | UPDATE | DELETE)
ON table_name FOR EACH ROW
BEGIN
--variable declarations
--trigger code
END;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is a text delimiter?

0 Answers  


What is row level locking?

0 Answers  


what is mysql optimization in brief?

0 Answers  


What is DDL in MySQL?

1 Answers  


What is the datatype of image?

0 Answers  






How can we change the data type of a column of a table?

0 Answers  


How do I backup mysql database on linux?

0 Answers  


How to represent ENUMs and SETs internally?

0 Answers  


How do I change mysql password?

0 Answers  


How can you add and remove any column of a table?

0 Answers  


How many rows can a mysql table hold?

0 Answers  


How to returns the columns and column information pertaining to the designated table.

0 Answers  


Categories