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 sql does mysql use?

572


What can you do with mysql?

577


How do I disconnect mysql workbench?

614


How to create a table index in mysql?

597


How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.

706






Why myisam is faster than innodb?

564


How do I restore a mysql database dump file in linux?

561


how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

1885


How to rename an existing column in a table?

615


What does do in mysql?

552


What is memory table?

575


What happens if you no create privilege in a database?

653


What are the advantages of a procedure?

563


Write a command with which mysql table can be repaired

619


How many rows can be inserted in mysql at a time?

592