Number Data types in MySQL : Integer Type « Data Type « SQL / MySQL

1.	Aggregate Functions
2.	Backup Load
3.	Command MySQL
4.	Cursor
5.	Data Type
6.	Database
7.	Date Time
8.	Engine
9.	Event
10.	Flow Control
11.	FullText Search
12.	Function
13.	Geometric
14.	I18N
15.	Insert Delete Update
16.	Join
17.	Key
18.	Math
19.	Procedure Function
20.	Regular Expression
21.	Select Clause
22.	String
23.	Table Index
24.	Transaction
25.	Trigger
26.	User Permission
27.	View
28.	Where Clause
29.	XML

SQL / MySQL » Data Type » Integer Type

Number Data types in MySQL

      



Data type        Acceptable values                  Storage requirements



TINYINT          Signed: -128 to 127                1 byte

                 Unsigned: 0 to 255

SMALLINT         Signed: -32768 to 32767            2 bytes

                 Unsigned: 0 to 65535

MEDIUMINT        Signed: -8388608 to 8388607        3 bytes

                 Unsigned: 0 to 16777215

INT              Signed: -2147483648 to 2147483647  4 bytes

                 Unsigned: 0 to 4294967295

INTEGER          INTEGER is a synonym for INT.      4 bytes



BIGINT           Signed: -9223372036854775808 to    8 bytes

                 9223372036854775807

                 Unsigned: 0 to 18446744073709551615

Related examples in the same category

1.	Integer Types in MySQL with Sizes and Ranges
2.	Int value: less than and equal
3.	Int value: larger and equals
4.	Int value: less than
5.	Int value: bigger
6.	INT(m), INTEGER(m): 32-bit integer (4 bytes, -2.147,483,648 to +2,147,483,647)
7.	Compare with integer literal
8.	Minus a constant value

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.