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

How to returns the columns and column information pertaining to the designated table.

575


What is mysqli_free_result?

511


What is view? How can you create and drop view in mysql?

491


What do you understand by mysql terminal?

528


Is mysql same as mariadb?

489






How to extract a unit value from a date and time?

499


What is mysqli_num?

512


Can you tell a way to know the number of days between the two given dates in php?

592


Why should I learn mysql?

492


all the queries used in sql

2162


How many sql dml commands are supported by 'mysql'?

479


Can we store images in mysql database?

488


How can you handle the –secure-file-priv in mysql?

519


Which datatype is used for email in mysql?

490


How to do login in mysql with unix shell.

552