methbkts/MySQLDatatypes.md

Last active September 5, 2019 12:16

Star (1) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/methbkts/78e6f5f886c9c603803588c4bf86b57c.js"></script>
Save methbkts/78e6f5f886c9c603803588c4bf86b57c to your computer and use it in GitHub Desktop.

Download ZIP

Raw

MySQLDatatypes.md

Numbers :

type	description	range	length	exemple
tinyint		`-128 to 127 (0-255)`	2⁸
smallint		`-32768 to 32767 (0-65535)`	2¹⁶
mediumint		`-8388608 to 8388607 (0-16777215)`	2²⁴	---
int		`-2147483648 to 2147483647 (0-4294967295)`	2³²	---
bigint		`-9223372036854775808 to 9223372036854775807 (0-18446744073709551615)`	2⁶⁴	---
decimal	`store exact numeric values, best for business uses`	---	---	---
float	---	---	---	---
double	---	---	---	`DOUBLE(5,2) -> 123.45`

Date & Hours :

date
datetime
timestamp
time
year

Strings :

char
varchar
tinytext
text
mediumtext
longtext
json

Lists :

enum
set

Binaries :

bit
binary
varbinary
tinyblob
blob
mediumblob
longblob

Geometry :

geometry
point
linestring
polygon
multipoint
multilinestring
multipolygon
geometrycollection

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment