Answer Posted / bhas

3 tables

1.table structure(.frm)
2.table data(.myd)
3.table index(.myi)

How can you add and remove any column of a table?

944

---

Is mysql written in c?

902

---

How to create a new table by selecting rows from another table in mysql?

992

---

What is use of mysql?

928

---

How to get help information from the server?

1053

---

Is mysql same as mariadb?

907

---

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

1634

---

What is bigint in mysql?

916

---

What is the difference between char and varchar?

1186

---

How do I edit a table in mysql?

895

---

How does select query work?

940

---

What are the 'mysql' command line options?

993

---

What is mysql in dbms?

1031

---

write a command to view the content of the table

899

---

What is mysql and why it is used?

1084

---