Answer / amith

FLOATs store floating point numbers with 8 place accuracy
and take up 4 bytes.
DOUBLEs store floating point numbers with 16 place accuracy
and take up 8 bytes.
REAL is a synonym of FLOAT for now.

Answer / gurmeet singh

A variable of type float only has 7 digits of precision
where as a variable of type double has 15 digits of
precision. If you need better accuracy, use double instead
of float.

Answer / baba

This is quite a screwed up forum.. All nuckle heads
shitting on the forum..!!!

Answer / mohamad nazim

double has 64 bit- show 8 digith after decimal point
float has 32 bit- show 4 digit after decimal point

Answer / mastan

Float has 4 bytes it display 8 places accuracy and double
has 8 bytes it displays 16 places accuracy.

Answer / vibhor

float has 32 bit- show 4 digit after decimal point
double has 64 bit- show 8 digith after decimal point
In short, The float is 32 bit while the double is 64 bit
I prepare job's paper from http://quizplaza.com

Answer / brianmanee

The Decimal, Double, and Float variable types are different
in the way that they store the values. Precision is the
main difference where float is a single precision (32 bit)
floating point data type, double is a double precision (64
bit) floating point data type and decimal is a 128-bit
floating point data type.

More info... http://net-informations.com/q/faq/float.html

Brian

Answer / leelu

float is float (4bytes)

double is double of float ;) (8 bytes) !!

Answer / 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
}

Answer / latha

float is a data type which stores floating values after
the .it takes maximum of 10 bis and it has 4bytes of memory
but in the double it has 8 bytes of memory nd it stores 15
digits after the .(point).

What happens if you no create privilege in a database?

0 Answers  

How do I start mysql database?

0 Answers  

How does mysql store data?

0 Answers  

Difference between CHAR and VARCHAR?

0 Answers  

Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

0 Answers  

What is foreign key in mysql?

0 Answers  

what are the optimization techniques for Query optimization performance issues and faster execution of queries

2 Answers   Infosys, Sierra Atlantica,

Can you shard mysql?

0 Answers  

Explain the difference between procedure and function in mysql?

0 Answers  

how many ways we can get the current date in mysql?

2 Answers  

What is the difference between truncate and delete in mysql?

0 Answers  

What is relational database in mysql?

0 Answers