INT(m), INTEGER(m): 32-bit integer (4 bytes, -2.147,483,648 to +2,147,483,647) : Integer Type « Data Type « SQL / MySQL

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

INT(m), INTEGER(m): 32-bit integer (4 bytes, -2.147,483,648 to +2,147,483,647)

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