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
What are triggers mysql?
What are the ways in which you can retrieve data in the result set of mysql using php?
Is mysql a odbc?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
Can you tell the difference between ereg_replace() and eregi_replace()?
Tell us something about heap tables?
What is truncate command?
Which is faster mysql or mongodb?
How to copy data from one server to another using php?
How to return query output in html format?
Which command is used to view the content of the table in mysql?
What is definer in mysql?
What do we use to remove duplicate records while fetching a data in mysql ?
How do I copy a table in mysql?