Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to create triggers in MySQL?

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


Please Help Members By Posting Answers For Below Questions

What is ndb in mysql?

959


Can you tell the difference between $message and $$message?

960


What are the benefits of mysql?

931


What are the limitations of mysql?

1040


What is trigger in mysql?

919


What is query log in mysql?

965


Can python connect to mysql?

1003


Can mongodb replace mysql?

925


What is max connection in mysql?

920


What is mysql connector used for?

941


Which storage engine is best in mysql?

946


How do I truncate all tables in mysql?

973


Explain % and _ inside like statement?

1005


How show all tables in mysql query?

915


What is the difference between procedure and function in mysql?

1013