初识MySQL（三）CRUD操作

• insert增加 

 

 　　update 更新　　　

update user set age=23 where name='zhang san';
update user set age=age+1 where id=3;

 

　　delete 删除

delete from user where age=23;
delete from user where age between 20 and 22;
delete from user;

　　

select查询

 

select * from user;
select id,nickname,name,age,sex from user;
select id,name from user;
select id,nickname,name,age,sex from user where sex='M' and age>=20 and age<=25;
select id,nickname,name,age,sex from user where sex='M' and age between 20 and
25;
select id,nickname,name,age,sex from user where sex='W' or age>=22;