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 command is used to delete the data from the table without deleting the table structure?
How can increase the performance of MySQL select query?
3 Answers RV Technologies, Span Systems,
Is mysql easy to learn?
How do I download mysql?
How do you stop an access query?
What is mvcc in mysql?
How to create a new view in mysql?
What is the use of mysql_close()?
How do I backup mysql database on linux?
What is mysql default port number?
What happens if a table has one column defined as TIMESTAMP?
How to see the database architecture in MySQL??
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)