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 do I use mysql?
What is the insert?
How to escape special characters in sql statements?
How do I select a database in mysql?
Write a program using the select statement, while loop.
What is difference between mongodb and mysql?
What is mysql url?
Can we rename database in mysql?
What are date and time intervals?
what is JOIN? Give example & types of join?
14 Answers iMedia, Millennium, RAM Software, Satyam,
What is max connection in mysql?
What are the ways in which you can retrieve data in the result set of mysql using php?