Explain the difference between FLOAT, DOUBLE and REAL.

Answer Posted / mastan

Float has 4 bytes it display 8 places accuracy and double
has 8 bytes it displays 16 places accuracy.

Is This Answer Correct ?    7 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

498


What is a text delimiter?

491


What is the return type of mysqli_query?

448


How to find second highest salary from a table?

521


How to check if value already exists in mysql database in php?

426






What are date and time data types?

474


What are the functions in mysql?

475


Is mysqli deprecated?

474


What is mysql57?

487


How would you get the current date in mysql?

630


What are stored procedures and functions?

452


can you tell the order of sql select statement? : Mysql dba

465


How to filter data from a mysql database table with php?

438


Tell us something about heap tables?

528


How do I clear a mysql database?

487