Differentiate between FLOAT and DOUBLE?



Differentiate between FLOAT and DOUBLE?..

Answer / 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

More MySQL Interview Questions

How will show all records containing the name "sonia" and the phone number '9876543210'

0 Answers  


How to list or view all databases from the mysql server.

0 Answers  


How triggers can be used in mysql?

0 Answers  


What are the types of index?

0 Answers  


What is a tinyint in mysql?

0 Answers  


what is the default port for mysql server? : Mysql dba

0 Answers  


What is myisamchk?

0 Answers  


Why is the basic difference between left join, right join and inner join?

0 Answers  


How to load data files into tables with 'mysqlimport'?

0 Answers  


What is mysql protocol?

0 Answers  


What is difference b/w composit key n primary key and forigion key?

4 Answers  


How do I edit a table in mysql?

0 Answers  


Categories