阿里天池SQL训练营学习笔记

CREATE DATABASE shop;
use shop;

CREATE TABLE Addressbook
(regist_no int not null primary key,
name varchar(128) not null,
address varchar(256) not null,
tel_no char(10),
mail_address char(20));

ALTER TABLE Addressbook ADD COLUMN postal_code CHAR(8) not null;

DROP TABLE Addressbook;

CREATE TABLE Addressbook
(regist_no int not null primary key,
name varchar(128) not null,
address varchar(256) not null,
tel_no char(10),
mail_address char(20));

ALTER TABLE Addressbook ADD COLUMN postal_code CHAR(8) not null;