Explain the difference between FLOAT, DOUBLE and REAL.
Answer Posted / sanah
In Computer Science terminology(world) Real numbers are those which have decimal points.
These real numbers are categorized in 2 ways.
1.Float and
2.Double
Memory used by these two differs based on the programming language on which we works.
For Example in C:-
Float:-It uses only 4 bytes of memory
Double:-It uses 8 bytes of memory
The only difference between these two is that---
Float can hold only 4 bytes(ex:2.4509)
Double is used to hold 8 bytes(ex:2.450877777777777777779)
i.e
if(real_no is larger)
{
we go for double;//remember double is a real
}
else
{
we go for float;//remember float is also a real
}
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to get last inserted id after insert data from a table in mysql?
What are the advantages of mysql in comparison to oracle?
What's the latest version of mysql?
What is the maximum connection pool size?
how can you test for null values in a database? : Mysql dba
What is mysql enterprise edition?
What is unique key in mysql?
What is the password of mysql?
How show all tables in mysql query?
Can foreign key have duplicate values?
What are the differences between char and varchar data types?
What is indexing in mysql?
How do I delete a row in mysql?
What are federated tables?
What is mysql architecture?