use student
select * from students
--连接值的方式插入多行数据
insert into students (ID,SName,Age,Sex)
select 18,'王1',19,0 union
select 19,'王2',22,1 union
select 20,'王3',24,0 union
select 21,'王4',25,1
--更新语句
update students set Sex=0
update students set Address='浙江金华'
--更新语句(限定条件)
update students set Address='浙江温州'
where SName='肖云斌'