Explain the difference between FLOAT, DOUBLE and REAL.
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / manager
float floats on water and double drowns in water
Is This Answer Correct ? | 21 Yes | 118 No |
What is sql in mysql?
What are the 5 r's of managing behaviors?
Can varchar be primary key?
How many primary keys can be there in a table?
Where’s database data actually stored? Is there a way to see the files which are stored?
How many sql dml commands are supported by 'mysql'?
What is the return type of mysqli_query?
Is pdo faster than mysqli?
How do you create a schema?
How to shutdown mysql server?
How can you see all indexes defined for a table?
What do I do if I forgot my mysql root password?