Float has 4 bytes it display 8 places accuracy and double has 8 bytes it

Explain the difference between FLOAT, DOUBLE and REAL.

Question Posted / mastan

Answer Posted / mastan

Float has 4 bytes it display 8 places accuracy and double
has 8 bytes it displays 16 places accuracy.

Is This Answer Correct ?

7 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is mysql protocol?

552

What is difference mysql and mysqli?

591

How to display top 10 rows in mysql?

651

Is foreign key indexed mysql?

539

How to see table's field formats or description of table .

536

What is clob datatype?

561

Where is the myisam table stored?

604

Why we use mysqli instead of mysql?

646

Is microsoft sql same as mysql?

584

List the different types of normalization?

592

If we use sum function in mysql, does it return sum of that row or for that column?

605

Can we store pdf files in mysql?

541

How we can see all indexes defined for a table in mysql?

556

What is max_used_connections in mysql?

565

What is mysql default port number?

612