
DROP DATABASE  IF EXISTS musicarchive;

CREATE DATABASE musicarchive;

use musicarchive

CREATE TABLE cd ( 
cd_number INT NOT NULL AUTO_INCREMENT, 
artist VARCHAR(30), 
title VARCHAR(30), 
genre VARCHAR(20), 
year INT(3), 
PRIMARY KEY (cd_number) );

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Massive Attack", "Blue Lines", "Trip Hop", 1991);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Massive Attack", "Protection", "Trip Hop", 1994);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Massive Attack", "Mezzanine", "Trip Hop", 1998);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Massive Attack", "100th Window", "Trip Hop", 2003);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Massive Attack", "Heligoland", "Trip Hop", 2010);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Led Zeppelin", "Led Zeppelin", "Rock", 1969);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Led Zeppelin", "Led Zeppelin II", "Rock", 1969);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Led Zeppelin", "Led Zeppelin III", "Rock", 1970);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Led Zeppelin", "Led Zeppelin IV", "Rock", 1971);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Led Zeppelin", "Houses of The Holy", "Rock", 1971);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Nils Petter Molvaer", "Khmer", "Fusion Jazz", 1997);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Nils Petter Molvaer", "Solid Ether", "Fusion Jazz", 2000);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Nils Petter Molvaer", "Barboon Moon", "Fusion Jazz", 2011);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Miles Davis", "Kind of Blue", "Jazz", 1959);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Miles Davis", "Sketches of Spain", "Jazz", 1960);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Miles Davis", "Bitches Brew", "Jazz", 1970);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Miles Davis", "Tutu", "Jazz", 1986);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Miles Davis", "Amandla", "Jazz", 1989);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Miles Davis", "Doo-Bop", "Jazz", 1992);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "John Mayall", "John Mayall Plays John Mayall", "Blues", 1964);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "John Mayall", "Blues Breakers with Eric Clapton", "Blues", 1966);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "John Mayall", "A Hard Road", "Blues", 1967);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "John Mayall", "The Turning Point", "Blues", 1967);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "John Mayall", "Jazz Blues Fusion", "Jazz Blues", 1971);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "John Mayall", "In the Palace of the King", "Blues", 2007);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "John Mayall", "Tough", "Blues Rock", 2009);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Igor Stravinsky", "Le Sacre du Printemps; The Firebird", "Classical", 2003);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Igor Stravinsky", "Works for Violin and Piano", "Classical", 1987);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "Ludwig van Beethoven", "The Five Piano Concertos", "Classical", 1995);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "The Indelicates", "American Demo", "Indie Rock", 2008);

INSERT INTO cd
(cd_number, artist, title, genre, year) 
VALUES (null, "The Indelicates", "American Demo", "Indie Rock", 2010);






