Discog, MySQL - rextester

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

DROP TABLE IF EXISTS discog;
CREATE TABLE discog
    (`id` int, `artist` varchar(50), `track` varchar(50), `year` int)
;
    
INSERT INTO discog
    (`id`, `artist`, `track`, `year`)
VALUES
    (1, 'Some Artist', 'Greatest Song Ever', 1999),
    (2, 'Some Artist', 'Greatest Song Ever', 1985),
    (3, 'Some Other Artist', 'Greatest Song Ever', 1995),
    (4, 'Some Artist', 'Another Song', 1991),
    (5, 'Some Other Artist', 'Greatest Song', 1990),
    (6, 'Some Other Artist', 'Greatest Song', 1981),
    (7, 'Some Artist', 'Another Song', 2001),
    (7, 'Some Other Artist', 'Another Song', 2004),
    (8, 'Some Artist', 'Greatest Song Ever', 2000)
;
SELECT * FROM discog;

DROP TABLE IF EXISTS discog_copy;
CREATE TABLE discog_copy (id INT, artist VARCHAR(50), track VARCHAR(50), year INT);
ALTER TABLE discog_copy ADD UNIQUE KEY (artist, track);
INSERT IGNORE INTO discog_copy SELECT * FROM discog ORDER BY year;

SELECT * FROM discog_copy;


absolute service time: 0,39 sec