Explain the difference between FLOAT, DOUBLE and REAL.

Answer Posted / mohamad nazim

double has 64 bit- show 8 digith after decimal point
float has 32 bit- show 4 digit after decimal point

Is This Answer Correct ?    13 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mysql common?

489


What are the advantages of mysql in comparison to oracle?

553


What is a join? Explain the different types of mysql joins.

700


How to drop an existing table in mysql?

559


Why do we use group by and order by function in mysql?

525






What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

517


Write a query to fetch duplicate records from a table using mysql?

506


Is postgresql better than mysql?

518


What is blob in mysql?

501


How can you retrieve a portion of any column value by using a select query?

449


What is the current root password of mysql?

494


How do I remove a user from mysql?

562


How to delete an existing column in a table?

491


How to show all records starting with the letters 'sonia' and the phone number '9876543210'

523


What are the similarities between a function and a procedure?

455