Explain the difference between FLOAT, DOUBLE and REAL.

Answer Posted / gurmeet singh

A variable of type float only has 7 digits of precision
where as a variable of type double has 15 digits of
precision. If you need better accuracy, use double instead
of float.

Is This Answer Correct ?    38 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are triggers mysql?

661


What are the ways in which you can retrieve data in the result set of mysql using php?

669


Is mysql a odbc?

673


What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

687


How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

758


Can you tell the difference between ereg_replace() and eregi_replace()?

753


Tell us something about heap tables?

718


What is truncate command?

640


Which is faster mysql or mongodb?

677


How to copy data from one server to another using php?

745


How to return query output in html format?

706


Which command is used to view the content of the table in mysql?

671


What is definer in mysql?

714


What do we use to remove duplicate records while fetching a data in mysql ?

708


How do I copy a table in mysql?

686