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

What is the latest version of php and mysql?

1136

What is a scalar function?

931

Is there a free version of mysql?

877

table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

1281

What is pdo :: fetch_assoc?

849

What do I do if I forgot my mysql root password?

836

Is mysql a free database?

891

What is a crosstab query?

898

How to set the time zone for MySQL to particular country time?

3144

What is truncate command?

874

Write command to import an mysql file?

963

What is difference between group by and order by clause?

909

Can I use mariadb instead of mysql?

865

What is horizontally scalable?

924

How do I insert multiple rows in a table?

843