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 sql in mysql?

0 Answers  


What are the 5 r's of managing behaviors?

0 Answers  


Can varchar be primary key?

0 Answers  


How many primary keys can be there in a table?

0 Answers  


Where’s database data actually stored? Is there a way to see the files which are stored?

0 Answers  






How many sql dml commands are supported by 'mysql'?

0 Answers  


What is the return type of mysqli_query?

0 Answers  


Is pdo faster than mysqli?

0 Answers  


How do you create a schema?

0 Answers  


How to shutdown mysql server?

0 Answers  


How can you see all indexes defined for a table?

0 Answers  


What do I do if I forgot my mysql root password?

0 Answers  


Categories