CREATE DATABASE shop;
use shop;
CREATE TABLE Addressbook
(regist_no int not null primary key,
name varchar(128) not null,
address varchar(256) not null,
tel_no char(10),
mail_address char(20));
ALTER TABLE Addressbook ADD COLUMN postal_code CHAR(8) not null;
DROP TABLE Addressbook;
CREATE TABLE Addressbook
(regist_no int not null primary key,
name varchar(128) not null,
address varchar(256) not null,
tel_no char(10),
mail_address char(20));
ALTER TABLE Addressbook ADD COLUMN postal_code CHAR(8) not null;