sql复制去重合并

#表复制
CREATE TABLE mytable01(
id INT,NAME VARCHAR(32),
sal DOUBLE,job VARCHAR(32),
depton INT
);
SELECT*FROM mytable01;
#演示自我复制
#把emp表复制到mytable01表中
SELECT*FROM emp
INSERT INTO mytable01(id,NAME,sal,job,depton)
SELECT empno,ename,sal,job,depton FROM emp

#自我复制
INSERT INTO mytable01(id,NAME,sal,job,depton)
SELECT *FROM mytable01

#如何删除一个表中的重复记录
CREATE TABLE mytable02 LIKE emp
INSERT INTO mytable02 SELECT*FROM emp
SELECT*FROM mytable02

#(1)去重mytable02表,先创建临时表tmp,用distinct去重
CREATE TABLE tmp LIKE mytable02
INSERT INTO tmp SELECT DISTINCT* FROM mytable02
SELECT*FROM tmp
#（2）将mytable02内容删除，把tmp表内容复制到mytable02中，删除临时表
DELETE FROM mytable02
INSERT INTO mytable02 SELECT*FROM tmp
DROP TABLE tmp

#合并查询union
SELECT ename,sal,job FROM emp WHERE sal>3000
UNION ALL
SELECT ename,sal,job FROM emp WHERE job='保安部部长'
#union all 不去重，union去重