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 |
What is a text delimiter?
What is row level locking?
what is mysql optimization in brief?
What is DDL in MySQL?
What is the datatype of image?
How can we change the data type of a column of a table?
How do I backup mysql database on linux?
How to represent ENUMs and SETs internally?
How do I change mysql password?
How can you add and remove any column of a table?
How many rows can a mysql table hold?
How to returns the columns and column information pertaining to the designated table.