create database if not exists Addressbook_db;
3.1
create table Addressbook(
regist_no int not null,
name varchar(128) not null,
address varchar(256) not null,
tel_no char(10),
mail_address char(20),
primary key(regist_no)
)defult char set utf8mb4;
3.2
alter table Addressbook add column postal_code char(8) not null;
3.3
drop table Addressbook;
3.4
create table Addressbook(
regist_no int not null,
name varchar(128) not null,
address varchar(256) not null,
tel_no char(10),
mail_address char(20),
postal_code char(8) not null,
primary key(regist_no)
)defult char set utf8mb4;