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 are views in mysql?

515


What are the difference between mongodb and mysql?

644


How you will show all data from a table.

517


Does mysql use sql?

490


What is mysql connection limit?

512






How do I declare a variable in mysql?

470


1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

1551


Can we create table in stored procedure?

484


What are the benefits of mysql?

474


What is mysql database server?

481


What is text in mysql?

491


What is the limitation of mysql?

473


What is identity in mysql?

501


How can you export the table as an xml file in mysql?

494


How to run a sql statement?

528