Explain the difference between FLOAT, DOUBLE and REAL.

Answer Posted / brianmanee

The Decimal, Double, and Float variable types are different
in the way that they store the values. Precision is the
main difference where float is a single precision (32 bit)
floating point data type, double is a double precision (64
bit) floating point data type and decimal is a 128-bit
floating point data type.

More info... http://net-informations.com/q/faq/float.html

Brian

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I select a database in mysql?

578


How many columns is too many mysql?

546


State the differences between mongodb and mysql.

624


How to Join tables on common columns.

716


What is auto increment in mysql?

594






how to connect a php script with the mysql database?

622


Differentiate CHAR_LENGTH and LENGTH?

671


What is longblob in mysql?

594


What is procedural api?

583


Can you tell a way to know the number of days between the two given dates in php?

667


How do you create a primary key?

562


What is a data directory?

596


What is regexp?

738


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

611


Is there a free mysql?

567