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 is the date format in mysql?

539


What is a left join mysql?

558


How can we encrypt and decrypt a data presented in a table using mysql?

624


What do ddl, dml, and dcl stand for?

550


What is row locking in mysql?

602






write a command to view the content of the table

583


How do you login to MySql using Unix shell?

693


What is the difference between truncate and delete?

671


Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

607


What are the similarities between a function and a procedure?

542


Which statement is used in a select query for partial matching?

700


How to get data from mysql in php?

528


How do I edit a table in mysql workbench?

515


What is prepared statement in mysql?

584


How many sql dml commands are supported by 'mysql'?

548