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 you name a table?

493


What is the use of innodb in mysql?

482


How to get a list of columns in an existing table?

500


What is mysql port?

564


How much does mysql enterprise cost?

490






How do I change the max connections in mysql?

470


Why is the basic difference between left join, right join and inner join?

552


Is mysql better than oracle?

479


How do I edit a stored procedure in mysql?

500


What is difference between oracle and mysql?

502


What is the difference between heap table and temporary table?

622


What is mysql in dbms?

489


Is mysql a backend?

522


What is data type for image in mysql?

457


How can you import tables from a sql file into a database by using the mysql client?

547