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
Can mysql function return a table?
How to drop an existing table in mysql?
What are date and time intervals?
How to rename an existing table in mysql?
What are the different tables present in MySQL?
Is mysqli secure?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
Is postgresql better than mysql?
How many TRIGGERS are allowed in MySql table?
What is full form of xampp?
Why is mysql used?
How to dump a table to a file with 'mysqldump'?
Is mongodb faster than mysql?
Why myisam is faster than innodb?
Why mysql is open source?