TINYINT(m) 8-bit integer (1 byte, -128 to +127); : Tiny Int « Data Type « SQL / MySQL






  1. SQL / MySQL
  2. Data Type
  3. Tiny Int

TINYINT(m) 8-bit integer (1 byte, -128 to +127);

   
mysql>
mysql>
mysql> CREATE TABLE a (
    ->  id INT NOT NULL AUTO_INCREMENT,
    ->  choice TINYINT NOT NULL,
    ->  ts TIMESTAMP,
    ->  PRIMARY KEY (id));
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> drop table a;
Query OK, 0 rows affected (0.00 sec)








Related examples in the same category

1.Define and use tiny int
2.Setting M to a higher value than the type allows will not allow you to extend its limit.
3.Tinyint as column type