本笔记为阿里云天池龙珠计划SQL训练营的学习内容,链接为:https://tianchi.aliyun.com/specials/promotion/aicampsql;
3.1
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)
) ;
3.2
ALTER TABLE Addressbook ADD COLUMN postal_code VARCHAR(8) not null;
3.3
drop table Addressbook;
3.4
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),
postal_code VARCHAR(8) not null,
PRIMARY KEY(regist_no)
) ;