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>