mysql>
mysql>
mysql> CREATE TABLE PLAYERS
-> (
-> PLAYERNO 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 (PLAYERNO)
-> );
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql>
mysql> SHOW COLUMNS FROM PLAYERS;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| PLAYERNO | int(11) | NO | PRI | NULL | |
| NAME | char(15) | NO | | NULL | |
| INITIALS | char(3) | NO | | NULL | |
| BIRTH_DATE | date | YES | | NULL | |
| SEX | char(1) | NO | | NULL | |
| JOINED | smallint(6) | NO | | NULL | |
| STREET | varchar(30) | NO | | NULL | |
| HOUSENO | char(4) | YES | | NULL | |
| POSTCODE | char(6) | YES | | NULL | |
| TOWN | varchar(30) | NO | | NULL | |
| PHONENO | char(13) | YES | | NULL | |
| LEAGUENO | char(4) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
12 rows in set (0.00 sec)
mysql>
mysql> drop table players;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql>
mysql>