SQL基础:初识数据库与SQL-安装与基本介绍
本笔记为阿里云天池龙珠计划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 char(8) NOT NULL;
-- 3.3
DELETE TABLE addressbook; -- delete 可以删除表中记录
-- 3.4
ROLL BACK ; -- roll back 可以恢复删除的数据,truncate table 则无法恢复
COMMIT;