Answer Posted / shikha grover

Select date_format(curdate(),'%M') ;

what is the difference between between and in operators in mysql?

1076

---

How do I free up space in mysql?

964

---

What is difference between oracle and mysql?

988

---

What is the difference between a heap table and temporary table?

983

---

How you can create a trigger in mysql?

1057

---

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

1087

---

What is root password?

967

---

How to insert dynamic values in mysql using php?

1184

---

How do you name a table?

933

---

What is mysql sleep process?

1076

---

What is the limitation of mysql?

1012

---

What is session variable in mysql?

1022

---

How do I run mysql on a mac?

1009

---

Is mysql frontend or backend?

945

---

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

1690

---