What are the other commands to know the structure of table using MySQL commands except explain command?

2 Answers   SigmaTree,

---

How to show table names with 'mysqlshow'?

0 Answers  

---

What you can use regular expression for in mysql?

0 Answers  

---

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

0 Answers  

---

What are the different types of triggers in mysql?

0 Answers  

---

What are the advantages and disadvantages of MySQL?

0 Answers   Satyam,

---

what is the difference between MyIsam and InnoDb engine?

2 Answers  

---

What's new in mysql 8?

0 Answers  

---

What is mysql ndb?

0 Answers  

---

What is mysql in dbms?

0 Answers  

---

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

0 Answers  

---

what is a cursor? : Mysql dba

0 Answers  

---