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 to use rank function in mysql?
Is mysql a scripting language?
What is heap table?
How we can get distinct columns values in mysql?
Does insert statement lock the table?
suppose server is running Suddenly down . what can you do? but i want do not down the server?
What is 'mysqlcheck'?
Which is better mysql or mssql?
How to see the create table statement of an existing table?
How do I stop a mysql service?
What is the use of i-am-a-dummy flag in mysql?
what do you mean by longblob Data type in MySql?