Search code examples
phpsqlmysqlprecisionnumerical

what's the purpose/point of the REAL() Datatype in mysql?

what's the purpose/point of the REAL() Datatype in mysql? You have float,double and decimal which i understand but where does the "real" datatype come into it? Any ideas?

Thank you in advance ;-)

is real the same as float or double?

Solution

  • MySQL treats REAL as a synonym for DOUBLE, unless the REAL_AS_FLOAT SQL mode is enabled.

    Source: MySQL 5.1 Reference Manual - Numeric Types