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

What are the security alerts while using mysql?

567


What is mysql database used for?

478


What is the difference between the primary and unique key in mysql?

450


What is RMS Migrations

1955


What you can use regular expression for in mysql? Support your answer with an example?

473






How many columns can you create for an index?

477


How can we optimize stored procedure?

480


What is mysql database server?

479


What are aggregate functions in mysql?

661


What is the command used to create a database using php and mysql?

649


How can you see all indexes defined for a table?

610


Can python connect to mysql?

470


What are the differences between innodb and myisam engines?

457


What is a deterministic function?

589


What does "i_am_a_dummy flag" do in mysql?

489