Not null varchar column : Varchar « Data Type « SQL / MySQL

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

Not null varchar column

     
mysql>
mysql> CREATE TABLE president
    -> (
    ->     last_name   VARCHAR(15) NOT NULL,
    ->     first_name  VARCHAR(15) NOT NULL,
    ->     suffix      VARCHAR(5) NULL,
    ->     city        VARCHAR(20) NOT NULL,
    ->     state       VARCHAR(2) NOT NULL,
    ->     birth       DATE NOT NULL,
    ->     death       DATE NULL
    -> );
Query OK, 0 rows affected (0.00 sec)

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

mysql>

   
    
    
    
    
  

Related examples in the same category