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 acid in mysql?
In mysql, what is joins? Explain
Can you tell what are various ways to create an index?
how to display nth highest salary from a table in a mysql query? : Mysql dba
How to change a password for an existing user via mysqladmin?
What is a mysql server?
What is field in mysql?
How do I use mysql?
How important is to list the column names when doing an insert?
How to use case expression?
How set mysql root password?
What are the features of Stored Procedures in MYSQL?