MEDIUMINT(m): 24-bit integer (3 bytes, -8,388,608 to +8,388,607) : MediumInt « Data Type « SQL / MySQL

1. SQL / MySQL
2. Data Type
3. MediumInt

MEDIUMINT(m): 24-bit integer (3 bytes, -8,388,608 to +8,388,607)

 
mysql>
mysql>
mysql> CREATE TABLE a (
    ->  id INT NOT NULL AUTO_INCREMENT,
    ->  choice MEDIUMINT 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)

mysql>

   
  

Related examples in the same category