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

How do I use mysql?

0 Answers  


What is the insert?

0 Answers  


How to escape special characters in sql statements?

0 Answers  


How do I select a database in mysql?

0 Answers  


Write a program using the select statement, while loop.

0 Answers  






What is difference between mongodb and mysql?

0 Answers  


What is mysql url?

0 Answers  


Can we rename database in mysql?

0 Answers  


What are date and time intervals?

0 Answers  


what is JOIN? Give example & types of join?

14 Answers   iMedia, Millennium, RAM Software, Satyam,


What is max connection in mysql?

0 Answers  


What are the ways in which you can retrieve data in the result set of mysql using php?

0 Answers  


Categories