CREATE TABLE table2 (
id INT NOT NULL UNIQUE AUTO_INCREMENT,
name VARCHAR(20) NOT NULL 
);
 
INSERT INTO table2(id,name) VALUES
(1,'Things Fall Apart'),
(2,'Things Fall Apart'),
(3,'The Famished Road'),
(4,'Things Fall Apart'),
(5,'The Famished Road'),
(6,'Thirteen cents'),
(7,'Thirteen cents');
 
CREATE  TABLE 
temp2(id VARCHAR(10), name VARCHAR(20))
TYPE=HEAP;
 
INSERT INTO temp2(name) SELECT DISTINCT name FROM table2;
 
DELETE FROM table2;
 
INSERT INTO table2(id,name) SELECT id,name FROM temp2;