• Newsticker

    Selasa, 17 April 2018

    Integer Types

    Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT

    MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINTMEDIUMINT, and BIGINT. The following table shows the required storage and range for each integer type.

    Table 11.1 Required Storage and Range for Integer Types Supported by MySQL
    TypeStorage (Bytes)Minimum Value SignedMinimum Value UnsignedMaximum Value SignedMaximum Value Unsigned
    TINYINT1-1280127255
    SMALLINT2-3276803276765535
    MEDIUMINT3-83886080838860716777215
    INT4-2147483648021474836474294967295
    BIGINT8-2^6302^63-12^64-1


    Sumber: https://dev.mysql.com/doc/refman/5.7/en/integer-types.html

    Tidak ada komentar:

    Posting Komentar

    Agama

    Jaringan

    Android

    Linux

    Catatan

    Mikrotik