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 foreign key in mysql?
What is the role of a limit in a mysql query?
How does mysql store dates?
How do I view data in mysql workbench?
What is a transaction? Describe mysql transaction properties.
What is mysql and mysqli?
Why do we use the mysql database server?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
How can you count the total number of records of any table?
If we use sum function in mysql, does it return sum of that row or for that column?
What is a trigger? How you can create a trigger in mysql?
What is the current version of mysql?
Does mysql use sql?
What does schema mean?
What is meant by mysqli?
