albums_seeder.sql

USE codeup_test_db;
TRUNCATE albums; #removes, ends up with same number, prevents copies
INSERT INTO albums(artist, name, release_date, sales, genre)
VALUES ('Michael Jackson', 'Thriller', 1982, 49200000,
        'pop, post-disco, funk, rock'),
       ('AC/DC', 'Back in Black', 1980, 29500000,
        'hard rock'),
       ('Whitney Houston', 'The Bodyguard', 1992, 32400000,
        'R&B, soul, pop, soundtrack'),
       ('Meat Loaf', 'Bat Out of Hell', 1977, 21700000,
        'hard rock, glam rock, progressive rock'),
       ('Eagles', 'Their Greatest Hits', 1976, 41200000,
        'country rock, soft rock, folk rock'),
       ('Pink Floyd', 'The Dark Side of the Moon', 1973, 24400000,
        'progressive rock'),
       ('Eagles', 'Hotel California', 1976, 31500000,
        'soft rock'),
       ('Bee Gees', 'Saturday Night Fever', 1977, 21600000,
        'disco'),
       ('Fleetwood Mac', 'Rumors', 1977, 27900000,
        'soft rock'),
       ('Shania Twain', 'Come On Over', 1997, 29600000,
        'country, pop'),
       ('One Greaser', 'Grease: The Original Soundtrack', 1978, 14400000,
        'rock and roll'),
       ('Led Zeppelin', 'Led Zeppelin IV', 1971, 29000000,
        'hard rock, heavy metal, folk rock'),
       ('Michael Jackson', 'Bad', 1987, 21100000,
        'pop, rhythm and blues, funk and rock'),
       ('Alanis Morissette', 'Jagged Little Pill', 1995, 24300000,
        'alternative rock'),
       ('Michael Jackson', 'Dangerous', 1991, 17000000,
        'New jack swing, R&B and pop'),
       ('Celine Dion', 'Falling into You', 1996, 21100000,
        'pop, soft rock'),
       ('The Beatles', 'Sgt. Pepper\'s Lonely Hearts Club Band', 1967, 18200000,
        'rock'),
       ('One Singer', 'Dirty Dancing', 1987, 17900000,
        'Pop, rock, R&B'),
       ('Adele', '21', 2011, 26400000,
        'Pop, soul'),
       ('Celine Dion', 'Let\'s Talk About Love', 1997, 19300000,
        'Pop, soft rock'),
       ('Metallica', 'Metallica', 1991, 25200000,
        'Heavy metal'),
       ('The Beatles', '1', 2000, 23500000,
        'rock'),
       ('The Beatles', 'Abbey Road', 1969, 14400000,
        'rock'),
       ('ABBA', 'Gold: Greatest Hits', 1992, 23000000,
        'Pop, disco'),
       ('Bruce Springsteen', 'Born in the U.S.A.', 1984, 19600000,
        'Heartland rock'),
       ('Madonna', 'The Immaculate Collection', 1990, 19500000,
        'Pop, dance'),
       ('Pink Floyd', 'The Wall', 1979, 18700000,
        'Progressive rock'),
       ('James Horner', 'Titanic: Music from the Motion Picture', 1997, 18100000, 'Film score'),
       ('Dire Straits', 'Brothers in Arms', 1985, 17700000,
        'Roots rock, blues rock, soft rock'),
       ('Nirvana', 'Nevermind', 1991, 16700000,
        'Grunge, alternative rock'),
       ('Santana', 'Supernatural', 1999, 20500000,
        'Latin rock'),
       ('Guns N\' Roses', 'Appetite for Destruction', 1987, 21900000,
        'Hard rock'),
       ('Elton John', 'Goodbye Yellow Brick Road', 1973, 8500000,
        'rock, pop rock, glam rock');