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)