How do I edit a trigger in mysql?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MySQL Interview Questions

How to drop an existing table in mysql?

0 Answers  


What's the difference between mysql and sql server?

0 Answers  


What is dirty read and phantom read?

0 Answers  


Explain the difference between MyISAM Static and MyISAM Dynamic?

1 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  






What is delimiter $$?

0 Answers  


How to drop an existing index in mysql?

0 Answers  


Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr

1 Answers  


How many columns can a table have?

0 Answers  


How to show all tables with 'mysql'?

0 Answers  


How can we find out which auto increment was assigned on Last insert?

0 Answers  


How to calculate the difference between two dates?

0 Answers  


Categories