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
What is the date format in mysql?
What is a left join mysql?
How can we encrypt and decrypt a data presented in a table using mysql?
What do ddl, dml, and dcl stand for?
What is row locking in mysql?
write a command to view the content of the table
How do you login to MySql using Unix shell?
What is the difference between truncate and delete?
Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');
What are the similarities between a function and a procedure?
Which statement is used in a select query for partial matching?
How to get data from mysql in php?
How do I edit a table in mysql workbench?
What is prepared statement in mysql?
How many sql dml commands are supported by 'mysql'?