NUMERIC
This page is part of MariaDB's Documentation.
The parent of this page is: Data Types for MariaDB Xpand
Topics on this page:
Overview
See DECIMAL.
USAGE
NUMERIC[(<precision>[,<scale>])] [SIGNED | UNSIGNED] [ZEROFILL]
DETAILS
Data Type | Precision | Scale |
|---|---|---|
| 0..255if omitted or
0, the default is 10 | 0..31the default is
0 |
|
EXAMPLES
While Xpand accepts the NUMERIC data type on table create, it is silently replaced with DECIMAL:
CREATE TABLE numeric_example (
example NUMERIC
);
SHOW CREATE TABLE numeric_example\G
*************************** 1. row ***************************
Table: numeric_example
Create Table: CREATE TABLE `numeric_example` (
`example` decimal(10,0)
) CHARACTER SET utf8 /*$ SLICES=3 */