新建表，插入数据，删除表，恢复删除掉的表

mysql> CREATE TABLE Addressbook
    -> (regist_no integer NOT NULL,
    -> name varchar(128) NOT NULL,
    -> address varchar(256) NOT NULL,
    -> tel_no char(10),
    -> mail_address char(20),
    -> primary key (regist_no));
Query OK, 0 rows affected


mysql> alter table Addressbook add column postal_code char(8) NOT NULL;
Query OK, 0 rows affected
Records: 0  Duplicates: 0  Warnings: 0


mysql> drop table Addressbook;

Query OK, 0 rows affected