几个mysql命令

select 

distinct: 去掉重复的查询 SELECTDISTINCT 列名称 FROM 表名称

where 条件查询  select * from student whereage>18;

and & or 多个条件查询 select* from student where age>18 and sex=1;

order by 排序 select name from studnet order by age;

      反排序 selectname from studnet order by age desc;

insert 插入 INSERTINTO 表名称 VALUES (值1, 值2,....)

      INSERTINTO table_name (列1, 列2,...) VALUES (值1,值2,....)

update 改变某个值 update studnet set name="kexiaobai",sex=1 wherestu_num=1206440138

delete 删除变种的行 delete from studnet where age 21; 不要加上*

in ,  select * from studnet where jobin("studnent","teacher"); 

     将job等于student或者等于teacher的全部选出来

between值1 and 值2

   select * from student where age (not) between 20 and30;选出年纪(不在)20到30岁的