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 acid in mysql?

0 Answers  


In mysql, what is joins? Explain

0 Answers  


Can you tell what are various ways to create an index?

0 Answers  


how to display nth highest salary from a table in a mysql query? : Mysql dba

0 Answers  


How to change a password for an existing user via mysqladmin?

0 Answers  






What is a mysql server?

0 Answers  


What is field in mysql?

0 Answers  


How do I use mysql?

0 Answers  


How important is to list the column names when doing an insert?

0 Answers  


How to use case expression?

0 Answers  


How set mysql root password?

0 Answers  


What are the features of Stored Procedures in MYSQL?

1 Answers  


Categories