Differentiate between FLOAT and DOUBLE?

Answer Posted / shiwanshu

Float() contain only the 2 decimal fraction value after the decmal point. e.g 2.23
Double() contain long fraction value after decimal point 23.999889...

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is text in mysql?

498


can you tell how can you display the maximum salary in sql? : Mysql dba

470


What are procedures in mysql?

493


What are the difference between and myisam and innodb?

519


How to show table structure mysql?

521






How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

534


What are the other commands to know the structure of a table using mysql commands except explain command?

543


How do you create a primary key?

479


In mysql, what is joins? Explain

534


What are enums used for in mysql?

493


How can we run batch mode in mysql?

542


What are the non-standard sql commands supported by 'mysql'?

512


How do I connect to a database in mysql workbench?

550


What sql does mysql use?

490


What is the datatype of image?

510