SQL学习打卡TASK1

T本笔记为阿里云天池龙珠计划SQL训练营的学习内容，链接为：https://tianchi.aliyun.com/specials/promotion/aicampsql；

SQL代码如下：

USE shop;

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)
);

ALTER TABLE addressbook ADD COLUMN postal_code CHAR(8) NOT NULL;

DROP TABLE addressbook;

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)
);

select * from addressbook;

INSERT INTO addressbook(
regist_no,name,address,tel_no,mail_address)
VALUES('002','小黑','深圳','10018','1067408935'),
('003','小林','深圳','10018','1067408935'),
('004','小白','深圳','10018','1067408935'),
('005','小哈','深圳','10018','1067408935');

select * from addressbook;

drop table addressbook;