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 to Return total number of rows.

0 Answers  


What is mysql uuid?

0 Answers  


How can you export the table as an xml file in mysql?

0 Answers  


Which command is used to view the content of the table in mysql?

0 Answers  


What is the purpose of mysql database?

0 Answers  






Do I need python for mysql?

0 Answers  


Can you tell how to find the number of rows in a resultset using php?

0 Answers  


What is MySQL?

0 Answers  


What is normalization and list the different types of normalization?

0 Answers  


What is pdo :: fetch_assoc?

0 Answers  


Explain MySQL optimization?

1 Answers  


How to calculate the difference between two time values?

0 Answers  


Categories