Answer Posted / a.kishan kumar

mysql> select
table_schema,sum(data_length+index_length)/1024/1024 from
information_schema.tables group by table_schema;

What is the phantom problem?

724

---

What are aggregate functions in mysql?

953

---

What is limit in mysql?

638

---

what is mysql optimization in brief?

2121

---

What are the objects can be created using CREATE statement?

710

---

Is mysql distributed?

695

---

What is mysql used for?

687

---

What is the difference between procedure and function in mysql?

688

---

What are the critical issues you have resolved in your company

1933

---

What is the password of mysql?

686

---

What is blob and clob?

690

---

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

1363

---

Write a program using the select statement, while loop.

656

---

How to create a table?

712

---

What is a data directory?

691

---