Differentiate between FLOAT and DOUBLE?



Differentiate between FLOAT and DOUBLE?..

Answer / shiwanshu

Float() contain only the 2 decimal fraction value after the decmal point. e.g 2.23
Double() contain long fraction value after decimal point 23.999889...

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How do you control the max size of a HEAP table?

1 Answers  


How to increment dates by 1 in mysql?

0 Answers  


What is mysql optimization?

0 Answers  


How can I create table in mysql?

0 Answers  


Can we store files in mysql?

0 Answers  






Is mysql a database?

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  


How can we get total number of records by query in mysql?

0 Answers  


What?s the default port for MySQL Server?

4 Answers   Yahoo,


What is the difference between unix timestamps and mysql timestamps?

0 Answers  


How to dump a table to a file with 'mysqldump'?

0 Answers  


How do I start and stop mysql on windows?

0 Answers  


Categories