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

Explain the difference between FLOAT, DOUBLE and REAL.

Question Posted / mohamad nazim

Answer Posted / mohamad nazim

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

Is This Answer Correct ?

13 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How to print message in mysql trigger?

1576

What are the advantages of a procedure?

959

How do I install the latest mysql on ubuntu?

1031

Is number a datatype in mysql?

992

What does blob mean in mysql?

1011

What do ddl, dml, and dcl stand for?

961

How to rename an existing table in mysql?

1080

What are the advantages of mysql in comparison to oracle?

1064

How to get data from mysql in php?

945

How to create a table index in mysql?

1013

How to use like conditions?

1035

Why should I use mysql?

994

What is identity in mysql?

1025

How does limit work in mysql?

948

Why are function needed?

995