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 mysql -u john -p command does?

969

How we can get distinct columns values in mysql?

1083

How do you create a schema?

949

What is a session in mysql?

965

What is row?

1077

What is longblob in mysql?

953

What is inner join in mysql?

907

Does mysql use tcp or udp?

916

What is truncate command?

940

Where’s database data actually stored? Is there a way to see the files which are stored?

978

How do you insert a table?

924

How do I set user privileges in mysql?

885

Tell us something about heap tables?

984

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

1007

What is dbms in mysql?

965