NUMBER
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 )
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.