INT2
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 SMALLINT.
USAGE
INT2[(<display_width>)] [SIGNED | UNSIGNED] [ZEROFILL]
DETAILS
Data Type | Minimum Value | Maximum Value |
---|---|---|
|
|
|
|
|
|
EXAMPLES
While Xpand accepts the INT2
data type on table create, it is silently replaced with SMALLINT
:
CREATE TABLE int2_example (
example INT2
);
SHOW CREATE TABLE int2_example\G
*************************** 1. row ***************************
Table: int2_example
Create Table: CREATE TABLE `int2_example` (
`example` smallint(6)
) CHARACTER SET utf8 /*$ SLICES=3 */