学习笔记TASK1-阿里天池SQL

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