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 role of a limit in a mysql query?

1009

How do I restore a mysql database dump file in linux?

976

How set mysql root password?

917

How to convert numeric values to character strings?

1063

What is a trigger in mysql?

1040

What is mysql_query?

857

using primary can we relate two table, with out foreign key?

2711

How to use triggers to track changes in mysql?

875

What is the difference between the LIKE and REGEXP operators?

1035

What is unique key in mysql?

991

What is the purpose of mysql database?

921

What are the functions used to encrypt and decrypt the data present in mysql?

1108

What is mysqli_select_db?

968

List some comparisons operators used in mysql?

987

How do I copy a table in mysql workbench?

884