上篇讲到了MySQL的常用DDL命令,本篇主要列出一些常用的DML(Data Manipulation Language):
1、插入记录:
insert into emp(age, ename, birth, sal, deptno) values(10, 'solidwang', '2010-01-20', 20, 1);
2、更新记录:
update emp set age = 30 where ename = 'solidwang'
3、删除记录:
delete from emp where ename = 'mary';
4、查询
(1)查询所有记录:
select * from emp;
(2)查询不重复的记录:
select distinct deptno from emp;
(3)排序和限制:
select * from emp order by sal desc limit 2;
(4)聚合:
select deptno, count(*) from emp group by deptno;