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 |
Which datatype is used for email in mysql?
How many columns is too many mysql?
Is SET Command is SQL Statement..?
Is mysql better than oracle?
How to delete a trigger in mysql?
How to connect html form to mysql database using php?
How do you control the max size of a HEAP table?
How to convert character strings to numeric values?
What are the purposes of using enum and set data types?
How to change a password for an existing user via mysqladmin?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
Can we rename database in mysql?