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

495


What does mysql flush hosts do?

471


How do I copy a table in mysql workbench?

451


What are stored procedures and functions?

466


How can an index be declared in mysql?

458






What is the difference between a database and a table?

493


What is triggers and how it can be used in mysql?

524


How to extract a unit value from a date and time?

489


How many mysql connections can handle?

483


What is the limit of mysql database?

485


What is the difference between mysql and oracle?

535


How do I add a column to a table in mysql?

467


How do you backup a database in mysql?

575


What is orm in mysql?

469


What language does mysql use?

428