Answer Posted / mastan

Float has 4 bytes it display 8 places accuracy and double
has 8 bytes it displays 16 places accuracy.

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

938

---

Why should I use mysql?

925

---

How many rows can a mysql table hold?

1013

---

How will you export tables as an xml file in mysql?

914

---

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

---

How to convert numeric values to character strings?

1062

---

What is the phantom problem?

1002

---

How can you import tables from a sql file into a database by using the mysql client?

1036

---

What are the differences between char and varchar?

1107

---

What is truncate in mysql?

953

---

How can you count the total number of records of any table?

921

---

What tools available for managing mysql server?

1023

---

What is trigger in mysql with example?

918

---

Is mysql better than oracle?

933

---

How to create and drop view in mysql?

915

---