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

Is mariadb faster than mysql?

469


What is the purpose of mysql database?

485


How is myisam table stored?

557


What are the two types of queries?

449


How do I stop a query in mysql workbench?

488






How do I remove a user from mysql?

562


What happens if null values are involved in expressions?

584


What is the limitation of mysql?

481


What is mysql default database?

480


What is query log in mysql?

502


Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

495


What is the difference between primary key and candidate key?

510


How can an index be declared in mysql?

462


what is database black box testing? : Mysql dba

588


What are the three types of queries?

461