What is the difference between float and double?



What is the difference between float and double?..

Answer / Veer Pal

In MySQL, both `FLOAT` and `DOUBLE` are used to store floating-point numbers. The main difference lies in their precision: `FLOAT` has a precision of 7 digits, while `DOUBLE` has a precision of 15 or 16 digits, depending on the version.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How to create a table?

1 Answers  


What are the similarities between a function and a procedure?

1 Answers  


What is the use of i-am-a-dummy flag in mysql?

1 Answers  


What are the steps required to view your mysql database?

1 Answers  


Is mysql a database?

1 Answers  


What is mysql in dbms?

1 Answers  


How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.

1 Answers  


Is mysqli deprecated?

1 Answers  


How do I clear a mysql database?

1 Answers  


How many columns is too many mysql?

1 Answers  


What is csv?

1 Answers  


What are the technical features of MySQL?

1 Answers  


Categories