Insert null value : Insert « Insert Delete Update « SQL / MySQL

1. SQL / MySQL
2. Insert Delete Update
3. Insert

Insert null value

      
mysql>
mysql>
mysql> CREATE TABLE EmployeeS(
    ->          EmployeeNO       INTEGER      NOT NULL,
    ->          NAME           CHAR(15)     NOT NULL,
    ->          INITIALS       CHAR(3)      NOT NULL,
    ->          BIRTH_DATE     DATE                 ,
    ->          SEX            CHAR(1)      NOT NULL,
    ->          JOINED         SMALLINT     NOT NULL,
    ->          STREET         VARCHAR(30)  NOT NULL,
    ->          HOUSENO        CHAR(4)              ,
    ->          POSTCODE       CHAR(6)              ,
    ->          TOWN           VARCHAR(30)  NOT NULL,
    ->          PHONENO        CHAR(13)             ,
    ->          LEAGUENO       CHAR(4)              ,
    ->          PRIMARY KEY    (EmployeeNO)           );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> INSERT INTO EmployeeS
    ->        (EmployeeNO, NAME, INITIALS, SEX,
    ->         JOINED, STREET, TOWN)
    -> VALUES (611, 'Jones', 'GG', 'M', 1977, 'Green Way', 'Stratford')
    -> ;
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO EmployeeS
    ->        (EmployeeNO, NAME, INITIALS, BIRTH_DATE,
    ->         SEX, JOINED, STREET, HOUSENO, POSTCODE,
    ->         TOWN, PHONENO, LEAGUENO)
    -> VALUES (611, 'Jones', 'GG', NULL, 'M', 1977,
    ->         'Green Way', NULL, NULL, 'Stratford', NULL, NULL);
ERROR 1062 (23000): Duplicate entry '611' for key 'PRIMARY'
mysql>
mysql>
mysql> drop table Employees;
Query OK, 0 rows affected (0.00 sec)

   
    
    
    
    
    
  

Related examples in the same category