Answer Posted / rohit

SELECT CURRENT_DATE();

How do I show users in mysql?

985

---

Does mysql support sequence?

882

---

How to escape special characters in sql statements?

917

---

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

1570

---

How do you use auto increment?

892

---

Is mysql a database?

882

---

What are the advantages of MySQL when compared with Oracle?

879

---

What are date and time intervals?

923

---

Is mysql free for enterprise?

849

---

Which statement is used in a select query for partial matching?

1138

---

Why MySQL is used?

966

---

How to use regular expression in pattern match conditions?

892

---

How do I find my mysql username and password?

916

---

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

950

---

How to enable or disable a row of a table using MySQL in struts?

4036

---