麻烦帮忙做一下 SQL查询的题~~~谢谢！！

2025-05-14 12:08:23

推荐回答（1个）

回答（1）：

1.答案是这样的
create table teacher
(
teacher_no char(10) primary key,
teacher_name char(10) not null,
teacher_sex char(10) check(teacher_sex='男' or teacher_sex='女' ),
teacher_birthday datetime,
teacher_prof char(10),
teacher_depart char(10)
)
go

2.select teacher_name from teacher where teacher_depart='计算机'

3.insert into teacher select '20020003','吴珊','女','1976-10-20','助教','计算机系'

4.物理删除其实就是删除表中的记录而不删除表的结构:

delete from teacher where teacher_name like '王珊'