表的复制和去重

表的复制和去重

---

---

1. 复制

1.
CREATE TABLE ss LIKE emp

2.
INSERT INTO ss 
SELECT * FROM ss

3. 
INSERT INTO SS
SELECT * FROM emp

4. 
INSERT INTO SS ('ASD',id,'sd')
SELECT id,'ss',`name` FROM emp

2. 去重
   

CREATE TABLE ss2 LIKE ss

INSERT INTO ss2 
SELECT DISTINCT * FROM ss

DELETE FROM ss

INSERT INTO ss 
SELECT DISTINCT * FROM ss2

SELECT * FROM ss


DROP TABLE SS2