NUMERIC

Synonym for DECIMAL. This type stores exact numeric data values.

Overview

See DECIMAL.

EXAMPLES

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) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}