Float is 8 bytes with 15 digits precision Double is same as float Real is

Explain the difference between FLOAT, DOUBLE and REAL.

Question Posted / leena

Answer Posted / leena

Float is 8 bytes with 15 digits precision
Double is same as float
Real is 4 bytes with 7 digits precision

Is This Answer Correct ?

13 Yes

63 No

Please Help Members By Posting Answers For Below Questions

What is mysqladmin flush hosts?

907

Is mysql case-sensitive?

834

What is mysql architecture?

955

Is mysql easy to learn?

875

What is blob and text in mysql?

1105

what are the different tables present in mysql? : Mysql dba

928

How to get data from mysql in php?

836

How do I start mysql database?

904

How to write after insert event update trigger on the same table in mysql?

906

Can we store videos in mysql database?

876

Is mysql same as sql?

838

What are numeric data types?

936

What is the maximum no of columns a table can have?

864

How do you select a table?

880

What is strict mode in mysql?

833