How to create triggers in MySQL?



How to create triggers in MySQL?..

Answer / 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

More MySQL Interview Questions

How to load a csv file into a table

0 Answers  


What are the advantages of mysql in comparison to oracle?

0 Answers  


How do I stop a query in mysql workbench?

0 Answers  


How to save images in MySQL?

2 Answers  


What is row level locking?

0 Answers  


How do I install mysql on windows 7?

0 Answers  


Does mysql support sequence?

0 Answers  


Can we create table in stored procedure?

0 Answers  


Is mysql a programming language?

0 Answers  


What is mysql uuid?

0 Answers  


Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

0 Answers  


How can you handle the –secure-file-priv in mysql?

0 Answers  


Categories