Synonym for DOUBLE. This keyword declares a normal-size (8-byte) floating-point number with double precision.
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