Answer Posted / pravallika

64

What are the method you will follow while sql installing

2316

---

I want to find out all databases starting with ‘test’, I have access to?

1107

---

What are the applications required to support mysql?

899

---

What is inner join in mysql?

849

---

Is foreign key indexed mysql?

842

---

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

1572

---

what is the default port for mysql server? : Mysql dba

986

---

Which is faster mongodb or mysql?

843

---

Is Mysql query is case sensitive?

962

---

What is database engine in mysql?

888

---

What is mysql uuid?

884

---

Is oracle mysql free?

822

---

What is the difference between mysql_fetch_assoc and mysql_fetch_array?

979

---

Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

920

---

what are the different tables present in mysql? : Mysql dba

930

---