DML是数据库的增删改查
1、插入一条数据:
insert into emp(age,ename,hiredate,sal,deptno) values(9,'zz','2018-03-1','2018',1);
2、插入某些数据:
insert into emp(age,ename) values(9,'ww');
3、插入多条数据:
insert into emp(age,ename,hiredate,sal,deptno) values(9,'zz','2018-03-1','2018',1),(9,'hh','2018-03-01','2018',2);
4、更新记录
update emp set sal = 400 where ename ='zz';
5、创建表dept
create table dept (depton int(3),deptname varchar(20));
6、添加两条数据
insert into dept(depton,deptname) values(1,'zz'),(2,'hh');
7、同时更新emp的sal字段和dept的deptname字段
update emp as a ,dept as b set a.sal = a.sal *b.depton,b.deptname =a.ename hwere a.deptno = b.depton;
8、删除记录
delete from emp where ename='zz';
9、查询记录
select * from emp;
10、查询不重复记录
select distinct deptno from emp;
11、条件查询
(1)查询deptno=1的
select * from emp where deptno =1;
(2)查询deptno=1 和 sal <300的
select * from emp where deptno = 1 and sal <300;
12、排序和限制
根据age排序
select * from emp order by age;
将deptno 相同的按sal由高到低排序
select * from emp order deptno ,sal desc;
13、显示一部分记录而不是全部的
显示sal排序后的3条记录
select * from emp order by sal limit 3;