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 does it mean to be case sensitive?
What is pragma serially_reusable and why is it used?
Where the database is stored in mysql?
How to add a new column to an existing table in mysql?
Can you tell what are various ways to create an index?
What is user in mysql?
Explain the difference between primary key and candidate key in mysql?
How to rename an existing table in mysql?
How do I connect to a mysql database?
How do I connect to a database in mysql workbench?
How will you export tables as an xml file in mysql?
How do I start mysql from command line?
What is dirty read and phantom read?
How to delete a database from mysql server.
How to dump a table to a file with 'mysqldump'?