Languages
Wiki
All Wiki Articles Create Wiki Article
programming
sql
mysql
mariadb
type
types
8 more ...
[Edit]
EN

MySQL - numeric data types

2 contributors
7 contributions
0 discussions
1 points
Created by:
maxsior322
347

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 
Donate to Dirask
Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!
Direct link
Join to our subscribers to be up to date with content, news and offers.

MySQL - Problems

MySQL - Create or replace view
MySQL - Create table if not exists
MySQL - Create table with AUTO_INCREMENT field
MySQL - Create table with FOREIGN KEY
MySQL - Create table with JSON field
MySQL - Create view if not exist
MySQL - Drop table if exists
MySQL - Drop view if exists
MySQL - GROUP BY multiple columns
MySQL - Insert JSON type value to the table
MySQL - Insert NULL values
MySQL - Select from multiple tables (using JOIN)
MySQL - Select from view
MySQL - UPDATE query with LIMIT
MySQL - Update all rows
MySQL - Update multiple rows at once
MySQL - add FOREIGN KEY to existing table
MySQL - add column to existing table
MySQL - average value for grouped rows
MySQL - boolean data type
MySQL - calculate average of column values and display the result with no decimals
MySQL - check version from command line
MySQL - concatenate multiple columns into one
MySQL - concatenate multiple rows into one field
MySQL - convert value to CHAR (using CAST() function)
MySQL - convert value to CHAR (using CONVERT() function)
MySQL - count characters in string (CHAR_LENGTH())
MySQL - count distinct values
MySQL - count duplicated rows
MySQL - count rows with NULL values
MySQL - database backup using Linux Command Line
MySQL - delete all duplicated rows except one
MySQL - delete row where column is empty string (blank)
MySQL - delete row where column is null
MySQL - duplicate table
MySQL - find all tables with specific column names
MySQL - find duplicated values
MySQL - find duplicated values in multiple columns
MySQL - find first row
MySQL - find row with null value in column
MySQL - find row with null value in one of many columns
MySQL - find rows where column is empty string (blank)
MySQL - get difference between two columns
MySQL - get size of every table in database (in MB)
MySQL - get table size (in MB)
MySQL - how to check database size?
MySQL - how to check existing table engine? (HeidiSQL example)
MySQL - make column values unique
MySQL - max value for grouped rows
MySQL - minimum value for grouped rows
MySQL - numeric data types
MySQL - restore database from backup using Linux Command Line
MySQL - search for NULL values in multiple columns
MySQL - select first N rows
MySQL - select last N rows
MySQL - select last row
MySQL - select rows with max value of column
MySQL - set root password
MySQL - sort in ascending or descending order
MySQL - sum value for grouped rows
MySql - get row position with SELECT query
MySql - insert data from one table to another
Mysql - create new column with index on existing database table with data
Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join