where条件，and与or关系

实例
创建表添加数据

create table clerk
(
	cleId int primary key,
	cleName nvarchar(50),
	age int
)

insert into clerk values(1,'贾宝玉',18)
insert into clerk values(2,'贾政',18)

--添加含有空值的成员
insert into clerk (cleId,cleName)values(3,'林黛玉')

select*from clerk

where语句

update clerk set age=38 where cleName='贾政'

update clerk set cleName='张三',age=40 where cleId=2

update clerk set cleId=4 where cleName='张三'

--把age为null的人命改为李四
--null不能用=,应该用is
update clerk set cleName='李四' where age is null

and与or

insert into clerk values(6,'较大',75)

--删除年龄在70-75之间的人,或者age为空的
delete from clerk where age>=70 and age<=75 or age is null

select*from clerk