Small Int « Data Type « SQL / MySQL






  1. SQL / MySQL
  2. Data Type
  3. Small Int
1.Define and use small int
2.SMALLINT(m): 16-bit integer (2 bytes, -32,768 to + 32,767)
3.Use smallint to store year
4.CREATE TABLE statement including two column definitions, SMALLINT data type and INT data type.
5.SMALLINT data type and a default value of 1
6.SmallInt calculation
7.Compare smallint value