INT UNSIGNED : Int « Data Type « SQL / MySQL

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

INT UNSIGNED

       
mysql>
mysql> CREATE TABLE attendee(
    ->     att_id      INT UNSIGNED NOT NULL AUTO_INCREMENT,
    ->     att_name    CHAR(100),
    ->     att_title   CHAR(40),
    ->     PRIMARY KEY (att_id)
    -> );
Query OK, 0 rows affected (0.01 sec)

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

   
    
    
    
    
    
    
  

Related examples in the same category