Explain the difference between FLOAT, DOUBLE and REAL.
- 14 Answers
- 70339 Views
- Yahoo, I also Faced
- E-Mail Answers
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 myisamchk?
Is mysql good for large database?
What is myisam?
How do I create a mysql username and password?
What is a heap table?
How many columns can be used for creating Index?
How to create a test table in your mysql server?
Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T
can you tell the order of sql select statement? : Mysql dba
State the differences between mongodb and mysql.
What is longblob in mysql?
Does adding an index lock a table?
How do you stop an access query?
What is dbms in mysql?
How do I quit mysql?
