Answer Posted / shweth

we can use ALIAS function for this
select tree AS plant
from table;
or simply we can skip writing AS but shoudnt write a comma
between the old and new column names.

How we can see all indexes defined for a table in mysql?

891

---

Write a query to retrieve a hundred books starting from 20th.

1473

---

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

1116

---

What is the function of myisamchk?

917

---

How to delete an existing column in a table?

896

---

Where is the myisam table stored?

910

---

Is mysqli secure?

842

---

How does triggers work in mysql?

905

---

How to declare variable in mysql trigger?

945

---

What is mysqlcommand?

944

---

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

1585

---

What is striped backup

2209

---

What are the functions in mysql?

898

---

Is mysql relational?

867

---

How do you kill a long running query in mysql?

846

---