FIXED

Synonym for DECIMAL. This keyword is used to define columns that require exact numeric precision, such as currency.

Overview

See DECIMAL.

EXAMPLES

CREATE TABLE fixed_example (
  example FIXED
);

SHOW CREATE TABLE fixed_example\G

*************************** 1. row ***************************
       Table: fixed_example
Create Table: CREATE TABLE `fixed_example` (
  `example` decimal(10,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

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