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 database engine in mysql?

934

How is oracle different from mysql?

1021

Is mysql good for large database?

925

What is 1nf 2nf 3nf?

981

How can you retrieve a particular number of records from a table?

933

What is myisam?

959

What is sqlyog?

1025

Write a query to fetch common records between two tables using mysql?

1025

What are features of mysql?

890

How to change a password for an existing user via mysqladmin?

981

How do I declare a variable in mysql?

944

How can I change database in mysql?

888

How to create trigger in mysql phpmyadmin?

1097

What is action query?

891

How do you create a new database in mysql?

913