新建表,插入数据,删除表,恢复删除掉的表
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