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 the use of mysqli_num_rows?

882

What is the difference between timestamp and datetime in mysql?

994

Is mysql free download?

819

What is the difference between myisam dynamic and myisam static in mysql?

957

How do I transfer data from one database to another in mysql?

868

Write a query to fetch duplicate records from a table using mysql?

901

What is ibdata1?

858

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

1036

How do I optimize a selected query in mysql?

894

explain GROUPBY & HAVING clause with examples.

2250

How to use like conditions?

938

what is database white box testing? : Mysql dba

956

What is unsigned in mysql?

887

How do I view data in mysql workbench?

975

How do I edit a stored procedure in mysql?

876