How to create triggers in MySQL?
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 |
How do you start and stop MySQL on Windows?
How to escape special characters in sql statements?
Where is mysql used?
how to display nth highest salary from a table in a mysql query? : Mysql dba
How do I start mysql manually?
How MySQL Optimizes DISTINCT?
How to include character strings in sql statements?
what is the Dynamic management views? where can you use?
What is msql?
How do I view data in mysql workbench?
Where’s database data actually stored? Is there a way to see the files which are stored?
How do I create a database in mysql workbench?