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
What is the hostname for mysql database?
Write a query to display current date and time?
Why should I use mysql?
How do I tune a mysql query?
What is the difference between a heap table and temporary table?
How do I change directories in mysql?
What is mysql in dbms?
Explain the difference between primary key and candidate key in mysql?
What is the difference between sql and mysql and oracle?
Can we rollback truncate in mysql?
What is InnoDB?
What are mysql functions?
What is the use of mysqli_num_rows?
Is mysql a relational database?
How do I create a mysql database?