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

What is the use of mysqli_num_rows?

678


Do I need python for mysql?

669


How to use regular expression in pattern match conditions?

719


How do I create a new database in mysql?

671


What is the default password for mysql?

639


What causes mysql too many connections?

655


how you will Create a database on the mysql server with unix shell.

741


What is difference between mysql and mysql workbench?

651


What does it mean to be case sensitive?

710


Why does mysql have so many connections?

662


What is inner join in mysql?

642


What is the latest version of mysql?

684


What are triggers in mysql?

647


What is cursor in mysql?

663


How to show all tables with 'mysql'?

723