Top community members
All Wiki Articles Create Wiki Article

Many years me and my friends we were volunteers on my university doing programming classes for young people.

I got main conclusion: Young people are awesome, especially students, because they always bring new and fresh ideas :)
* I loved to do it but my time is limited

  I decided to create something that will help millions of students

Now I am here

co-founder

MySQL - numeric data types

0 contributions
1 points

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 
0 contributions

Checkout latest Findings & News:

Checkout latest questions:

Checkout latest wiki articles:

Hey 👋
Would you like to know what we do?
  • Dirask is IT community, where we share coding knowledge and help each other to solve coding problems.
  • We welcome everyone,
    no matter what the experience,
    no matter how basic the question is,
    this community will help you.
Read more