INT

You are viewing an old version of this article. View the current version here.

Syntax:

INT[(M)] [UNSIGNED] [ZEROFILL]

Description:

A normal-size integer. When marked UNSIGNED, it ranges from 0 to 4294967295, otherwise its range is -2147483648 to 2147483647 (SIGNED - default). If a column has been set to ZEROFILL, all values will be prepended by zeros so that the INT value contains a number of M digits.

Note: If the ZEROFILL attribute has been specified, the column will automatically become UNSIGNED.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.