use music;

DROP TABLE IF EXISTS cds;

CREATE TABLE cds (
   cd_id int(5) NOT NULL,
   name varchar(50),
   artist varchar(50),
   PRIMARY KEY (cd_id)
);

INSERT INTO cds VALUES
  (1, 'Mudlark', 'Leo Kottke'),
  (2, 'My Feet Are Smiling', 'Leo Kottke'),
  (3, 'Lucky The Man', 'Wizz Jones'),
  (4, 'The Blue Idol', 'Altan');

SELECT name, artist FROM cds;

INSERT INTO cds VALUES
  (5, 'Return of the Repressed', 'Leo Kottke');

SELECT name, artist FROM cds WHERE cd_id = 5;

UPDATE cds SET artist = 'John Fahey' WHERE cd_id = 5;

SELECT name, artist FROM cds;