其实是补之前没交的sql作业
1.非常基本的操作
新建数据库
create database L4C2
新建表
PID为主键
create table L4C2.dbo.Person
(
PID nchar(15),
PName nchar(25),
PRole nchar(10),
Lucky int,
Ammo int
primary key(PID)
)
增加列
alter table L4C2.dbo.Person add Ping int
修改列
修改列的数据类型
alter table L4C2.dbo.Person alter column Lucky varchar(10)
删除列
alter table L4C2.dbo.Person drop column Lucky
给表增加行
增加多行,给所有列赋值
insert into L4C2.dbo.Person values
(1234567,'EVO.T im a','Ellis',700,230),
(1234568,'EVO.Star','Smoker',0,225),
(1234569,'Double.Mayuyu','Coach',80,40),
(1234570,'dec.nv','Nick',0,233),
(1234571,'kain.nv',