数据库（实验3 数据操作 增 删 该 查）

Teaher

Student

Course

test1

test2

数据操作

---

/*插入数据*/
use testbase2
go 
insert into Course values('C1','程序设计','1')
go
/*修改数据*/
use testbase2
go 
update Teacher set PROF ='副教授' where TN = '王平'
go
/*删除数据*/
use testbase2
go 
delete from Teacher where TN = '王平'
go
/*查询数据库*/
use testbase2
go
select * from Teacher
go

/*复制数据库表（复制数据库表Student生成一新数据库表test1）*/
use testbase2
go 
select * into test1 from Student
go
/*用Sql复制数据库表Teacher中”男“教师记录，生成一新数据库表test2*/
use testbase2
go 
select TN,SEX,AGE,PROF into Test2 from Teacher
where SEX = '男'
go
/*为表test3在TN上创建主键*/
/*注意，创建主键的属性首先要保证允许null值*/
use testbase2 
go
alter table test3
add constraint PK_TN PRIMARY KEY(TN)
go
SELECT * FROM test3
/*1用sql语句创建数据库TEST_C,并以列的形式创建PRIMARY KEY约束*/
use testbase2
go
create table TEST_S(
	CNO CHAR(2) CONSTRAINT PK_TEST_S PRIMARY KEY,
	CN CHAR(2),
	CT TINYINT
	/*2一个表不能有多次主键的创建*/
	/*CONSTRAINT PK_TEST_S PRIMARY KEY(CN,CT)*/
)
go

/*3对已有表TEST_C进行创建主键*/
use testbase2
go
alter table TEST_C
add constraint PK_TEST_C PRIMARY KEY(CN,CT)
go

---