DOUBLE PRECISION

Synonym for DOUBLE. This keyword declares a normal-size (8-byte) floating-point number with double precision.

Syntax

DOUBLE PRECISION[(M,D)] [SIGNED | UNSIGNED | ZEROFILL]
REAL[(M,D)] [SIGNED | UNSIGNED | ZEROFILL]

Description

REAL and DOUBLE PRECISION are synonyms for DOUBLE.

Exception: If the REAL_AS_FLOAT SQL mode is enabled, REAL is a synonym for FLOAT rather than DOUBLE.

EXAMPLES

CREATE TABLE double_precision_example (
  example DOUBLE PRECISION
);

SHOW CREATE TABLE double_precision_example\G
<</code>>

<<sql>>

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

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}