Languages
[Edit]
EN

MySQL - numeric data types

1 points
Created by:
AnnLen
1777

In MySQL / MariaDB available are following numeric data types:

Type

Storage

(bytes)

Minimum value

(signed/unsigned)

Maximum value

(signed/unsigned)

Desciprtion
TINYINT1-128
0
127
255
Integer number
SMALL2-32768
0
32767
65535
Integer number
MEDIUMINT3-8388608
0
8388607
16777215
Integer number
INT4-2147483648
0
2147483647
4294967295
Integer number
BIGINT8-9223372036854775808
0
9223372036854775807
18446744073709551615
Integer number
DECIMALup to 30  Fixed-point number
FLOAT4 or 8  Floating point number
DOUBLE8  Floating point number
BIT(n + 7)/80 at position1 at position

Binary number sequence

References

  1. Data Type Storage Requirements - MySQL 8.0 Docs 
Hey 👋
Would you like to know what we do?
  • Dirask is a friendly IT community for learners, professionals and hobbyists to share their knowledge and help each other in extraordinary easy way.
  • We welcome everyone,
    no matter what the experience,
    no matter how basic the question is,
    this community will help you.