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 the differences between innodb and myisam engines?

540


Does mysql need a server?

564


Write a query to count the number of rows of a table in mysql.

556


Why are function needed?

587


Is pdo more secure than mysqli?

540






How do I flush privileges in mysql?

580


How to Set a root password if there is on root password.

663


how to connect a php script with the mysql database?

622


What are enums used for in mysql?

566


What is insert query in mysql?

544


Why we use mysql database?

550


Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

573


How many columns can be used for creating Index?

652


Does mysql support nosql?

562


What is foreign key in mysql?

673