Explain the difference between FLOAT, DOUBLE and REAL.

Answer Posted / amith

FLOATs store floating point numbers with 8 place accuracy
and take up 4 bytes.
DOUBLEs store floating point numbers with 16 place accuracy
and take up 8 bytes.
REAL is a synonym of FLOAT for now.

Is This Answer Correct ?    191 Yes 37 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the innodb in mysql?

508


What is the use of mysqli_query?

457


Why should I learn mysql?

490


How are mysql timestamps seen to a user?

512


How to use rank function in mysql?

482






What is max connections in mysql?

492


What is a storage engine?

561


What is mysql connection limit?

521


What is max_used_connections in mysql?

490


How do I find users in mysql?

533


Why mysql is so popular?

516


Can a table have multiple primary keys?

491


What is unique key in mysql?

515


Where is the myisam table stored?

532


How to find the unique values if the value in the column is repeated?

560