Answer Posted / antu

SQL is structural quary language but mysql is database package.

What is the full meaning of mysql?

493

---

What's new in mysql 8?

568

---

How do I quit mysql?

494

---

What is the current version of mysql?

496

---

Where the database is stored in mysql?

499

---

---

Why do we use views instead of tables?

502

---

What are stored procedures and functions?

478

---

How to show table structure mysql?

524

---

How do you name a table?

495

---

What is difference between schema and table?

483

---

How to dump one database for backup.

507

---

What is information_schema in mysql?

478

---

How to convert numeric values to character strings?

524

---

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

1168

---

What are the security alerts while using mysql?

577

---