-- 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));
-- 2添加列
alter table addressbook add column postal_code char(8) not null;
-- 3删除表addressbook
drop table addressbook;
-- 4回复被删除的表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),
postal_code char(8) not null,
primary key (regist_no));
天池sql训练营task1
最新推荐文章于 2024-07-31 22:18:21 发布