Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between FLOAT, DOUBLE and REAL.
- 14 Answers
- 75256 Views
- Yahoo, I also Faced
- E-Mail Answers
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 |
Where MyISAM table will be stored and also give their formats of storage?
How can we change the name of a column of a table?
Why does mysql have so many connections?
What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?
How much does mysql cost?
Is mysql relational?
what programming language which is used for testing and developement in sql?
How do I delete a mysql user?
What is a result set object?
how to repair a table in mysql?
How many ways to get the current time?
How to get data from mysql in php?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
