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 (7,'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 tempTableName LIKE contacts; CREATE INDEX index_id ON contacts(id,email); INSERT INTO tempTableName(id,email) SELECT DISTINCT * FROM contacts; TRUNCATE TABLE contacts; INSERT INTO contacts SELECT * FROM tempTableName; DROP TABLE tempTableName; SELECT * FROM contacts;