1 of 1

REAL

Synonym for DOUBLE. In standard SQL mode, REAL is a double-precision floating-point number.

Overview

EXAMPLES

CREATE TABLE real_example (
  example REAL
);

SHOW CREATE TABLE real_example\G

*************************** 1. row ***************************
       Table: real_example
Create Table: CREATE TABLE `real_example` (
  `example` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

REAL

Synonym for DOUBLE. In standard SQL mode, REAL is a double-precision floating-point number.

Overview

See DOUBLE.

EXAMPLES

CREATE TABLE real_example (
  example REAL
);

SHOW CREATE TABLE real_example\G

*************************** 1. row ***************************
       Table: real_example
Create Table: CREATE TABLE `real_example` (
  `example` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1