SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE contacts ( id INT, email varchar(100) ); INSERT INTO contacts (id,email) VALUES (1,'aaa@aaa.com'); INSERT INTO contacts (id,email) VALUES (2,'bbb@aaa.com'); INSERT INTO contacts (id,email) VALUES (3,'cc@aaa.com'); INSERT INTO contacts (id,email) VALUES (4,'bbb@aaa.com'); INSERT INTO contacts (id,email) VALUES (5,'aaa@aaa.com'); INSERT INTO contacts (id,email) VALUES (6,'ddd@aaa.com'); INSERT INTO contacts (id,email) VALUES (1,'aaa@aaa.com'); INSERT INTO contacts (id,email) VALUES (8,'ccc@aaa.com'); INSERT INTO contacts (id,email) VALUES (9,'aaa@aaa.com'); INSERT INTO contacts (id,email) VALUES (10,'bbb@aaa.com'); CREATE TABLE contacts2 ( id INT, email varchar(100) ); /*ALTER TABLE contacts2 ADD UNIQUE INDEX idx_name (id); /*INSERT INTO contacts2 SELECT * FROM contacts;*/ SELECT * FROM contacts2;