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

How do you start and stop MySQL on Windows?

3 Answers  


How to escape special characters in sql statements?

0 Answers  


Where is mysql used?

0 Answers  


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

0 Answers  


How do I start mysql manually?

0 Answers  


How MySQL Optimizes DISTINCT?

0 Answers  


How to include character strings in sql statements?

0 Answers  


what is the Dynamic management views? where can you use?

1 Answers   ACC,


What is msql?

0 Answers  


How do I view data in mysql workbench?

0 Answers  


Where’s database data actually stored? Is there a way to see the files which are stored?

0 Answers  


How do I create a database in mysql workbench?

0 Answers  


Categories