-- 单条插入 INSERT INTO emp(ename, sal) VALUES('dony', 1000); -- 批量插入 INSERT INTO dept VALUES(5, 'dept5'),(6, 'dept6'); INSERT INTO dept(deptno, deptname) VALUES(5, 'dept5'),(6, 'dept6'); -- 单表更新 UPDATE emp SET sal=4000 WHERE ename='lisa'; -- 多表同时更新 UPDATE emp a, dept b SET a.sal = a.sal * b.deptno ,b.deptname = a.ename WHERE a.deptno = b.deptno; -- 单表数据删除(where条件不加,会删除全表数据) DELETE FROM emp WHERE ename = 'dony'; -- 多表数据删除(where条件不加,会删除全表数据) DELETE a, b FROM emp a, dept b WHERE a.deptno = b.deptno AND a.deptno=3;