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 longblob in mysql?
Why do we use preparedstatement?
Where is mysql password stored?
What is the difference between heap table and temporary table?
What is DML in MySQL?
Write a query to display current date and time?
What is the default port of mysql server?
How do I show users in mysql?
Can we create table in stored procedure?
Consider you have the following three tables which have to be linked together.
What is difference between inner vs self vs cross?
Can you tell the difference between ereg_replace() and eregi_replace()?
Oracle (3253)
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)