Explain the difference between FLOAT, DOUBLE and REAL.

Answers were Sorted based on User's Feedback



Explain the difference between FLOAT, DOUBLE and REAL...

Answer / boobalan

Float is data type which holds the 8 bytes memory to
holds the floating values even if we give the values in
integer(4)it takes as float(4.0).
Double is also same to the float that is also takes 8
bytes main purpose is to holds the long values of varible
(example:phone no),thank you.......

Is This Answer Correct ?    2 Yes 12 No

Explain the difference between FLOAT, DOUBLE and REAL...

Answer / leena

Float is 8 bytes with 15 digits precision
Double is same as float
Real is 4 bytes with 7 digits precision

Is This Answer Correct ?    13 Yes 63 No

Explain the difference between FLOAT, DOUBLE and REAL...

Answer / manager

float floats on water and double drowns in water

Is This Answer Correct ?    21 Yes 118 No

Explain the difference between FLOAT, DOUBLE and REAL...

Answer / fsdfsdfs

double is double
float is float

Is This Answer Correct ?    30 Yes 201 No

Post New Answer

More MySQL Interview Questions

What is mysql architecture?

0 Answers  


Can you tell a way to know the number of days between the two given dates in php?

0 Answers  


Does mysql support nosql?

0 Answers  


What is pdo in php mysql?

0 Answers  


Is mysql a nosql database?

0 Answers  






What are the benefits of mysql?

0 Answers  


How do I transfer data from one database to another in mysql?

0 Answers  


Can we rollback truncate in mysql?

0 Answers  


How do you rename a procedure in mysql?

0 Answers  


What is query design?

0 Answers  


Why we use mysql workbench?

0 Answers  


How you will Show unique records.

0 Answers  


Categories