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 mysql default database?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
Does mysql need a server?
Is mysql good for large database?
How to see table's field formats or description of table .
How do I copy a table in mysql workbench?
Can mysql and mariadb coexist?
What are the benefits of mysql?
Can we rollback truncate in mysql?
How do I create a schema in mysql?
What is clob datatype?
How does mysql clustering work?
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)