ning518888的博客

原创 学习笔记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 N