NUMBER

Oracle-compatible synonym for DECIMAL. This type is used for fixed-point arithmetic.

NUMBER[(M[,D])] [SIGNED | UNSIGNED | ZEROFILL]

In Oracle mode, NUMBER is a synonym for DECIMAL.

EXAMPLES

Number_Example

SET sql_mode='oracle';

CREATE TABLE number_example (
  example NUMBER
);

SHOW CREATE TABLE number_example\G

*************************** 1. row ***************************
       Table: number_example
Create Table: CREATE TABLE "number_example" (
  "example" double DEFAULT NULL
)

_{This page is licensed: CC BY-SA / Gnu FDL}