DEC
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
DEC[(<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 DEC data type on table create, it is silently replaced with DECIMAL:
CREATE TABLE dec_example (
example DEC
);
SHOW CREATE TABLE dec_example\G
*************************** 1. row ***************************
Table: dec_example
Create Table: CREATE TABLE `dec_example` (
`example` decimal(10,0)
) CHARACTER SET utf8 /*$ SLICES=3 */