Answer / hrindows@gmail.com

The use of ENUM will limit the values that can go into a table. For a case, a user can create a table giving specific month values and other month values would not enter into the table.

What is the storage engine used for MySQL?

1 Answers  

---

How many triggers are possible in mysql?

0 Answers  

---

How to use triggers to track changes in mysql?

0 Answers  

---

How to get full name of monthname ?

4 Answers  

---

What is view in mysql?

0 Answers  

---

How can we get the number of rows affected by query?

0 Answers  

---

What are the types of queries?

0 Answers  

---

Is mysql a free database?

0 Answers  

---

mazimum size of a database in mysql? when we create a table then how many tables actually created? write there name?

1 Answers  

---

What is the usage of "i-am-a-dummy" flag in mysql?

0 Answers  

---

How database are managed?

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  

---