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 start mysql in ubuntu?

453


What is difference between mysql and mysql workbench?

439


Write a query to create a database and a table?

472


Do while loop in mysql procedure?

477


How do I free up space in mysql?

473






How do I edit a database in mysql workbench?

467


How do I copy a table in mysql workbench?

436


What is a crosstab query?

493


How many types of indexes are there in mysql?

458


Which is faster innodb or myisam?

494


How do I install mysql on windows 10 64 bit?

451


What is join in mysql? What are the different types of join?

489


Is mysql free for enterprise?

472


What is a string in mysql?

444


How do I start mysql database?

456