Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 View All Answers
What is a procedure example?
Is mariadb better than mysql?
How to print message in mysql trigger?
How to control the max size of a heap table?
What ascii 31?
Can we use mysql and mysqli together?
How do I exit mysql?
What is mysqladmin flush hosts?
How do you know if your mysql server is alive?
How do you concatenate strings in mysql?
explain GROUPBY & HAVING clause with examples.
What is sqlyog?
What are the mysql database files stored in system ?
What is the function of myisamchk?
What is auto increment in mysql?
