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 |
how to Return total number of rows.
What is mysql uuid?
How can you export the table as an xml file in mysql?
Which command is used to view the content of the table in mysql?
What is the purpose of mysql database?
Do I need python for mysql?
Can you tell how to find the number of rows in a resultset using php?
What is MySQL?
What is normalization and list the different types of normalization?
What is pdo :: fetch_assoc?
Explain MySQL optimization?
How to calculate the difference between two time values?