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

Can I copy mysql data directory?

494


How do I create a mysql database?

495


What is trigger in mysql?

493


How do I disable mysql?

507


What is a procedure example?

498






What is the use of innodb in mysql?

482


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

552


Restore database (or database table) from backup.

562


What is 'mysqladmin' in mysql?

527


How you will Show unique records.

548


How do I download a mysql community server?

450


What is the use of count function in mysql?

562


How to enter microseconds in sql statements?

524


How do we use % when performing a search query?

531


What are the steps required to view your mysql database?

614