Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 352
Imran Avatar asked Jan 22 '26 00:01

Imran


1 Answers

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

like image 180
Daniel Vassallo Avatar answered Jan 24 '26 13:01

Daniel Vassallo