mysql 常用操作sql语句，增删改查

消除重复记录行：select distinct name from student; 消除student表中name列下重复的记录消除。
给表名起别名：as关键字 ，可省略
正则：rlike
/*增删改查SQL语句/
– 插入
insert INTO student(id,name,sex,grade) values (1001,‘郭美伶’,‘女’,‘180’);
insert INTO student values(1002,‘明明’,‘男’,‘Y2’,null);
insert INTO student(id,name,grade) values (1003,‘小燕’,‘Y2’);
insert INTO student values (1004,‘小红’,’ ‘,‘S2’,’ ');
– 查询
select * from student;（非限定表名） 或数据库名字.表名（限定表名）
select * from student where id=‘1001’;
select grade from student GROUP BY grade; 分组
select * from student ORDER BY grade desc; desc降序 asc升序
select COUNT(*) 人数 from student;
select COUNT(name) 人数 from student; 空值不会被统计
having 过滤聚集之后的记录行，类似于where。
– 修改
update student set id=‘3003’ where id=‘1003’;
update student set note=‘aa’ where name=‘小燕’;
– 删除
delete from student where note is not null;
delete from student where id=‘1001’;

where后可跟条件运算符，算术运算符，逻辑运算符
整除：:x div y
与=相同，并支持null值比较：x<=>y
<>不等于
返回a-b之间的数据：between a and b
is null
is not null
返回括号里的信息的数据：in（）；
模糊查询：匹配0-多个字符：like ‘%’; _匹配单个字符