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


Please Help Members By Posting Answers For Below Questions

How do I find users in mysql?

783


What is mysql gpl?

642


What is default password for mysql?

673


What is meant by sharding?

679


How to Join tables on common columns.

835


What is the data type for image?

820


What is localhost in mysql?

762


What are the steps involved in query processing?

646


Is mysql query case sensitive?

715


What is the datatype of image in mysql?

666


How do I truncate all tables in mysql?

680


What is the use of i-am-a-dummy flag in mysql?

747


Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1219


How to set mysql variable in php?

694


How to analyze tables with 'mysqlcheck'?

906