Select Code to Download

CREATE TABLE artists (
  first_name text default NULL,
...
  band       text default NULL,
  id         int(5)   NOT NULL auto_increment
);

INSERT INTO artists (first_name, last_name) VALUES ('Billy','Joel');
INSERT INTO artists (band)                  VALUES ('AC/DC');

CREATE TABLE albums (
  name   text       NOT NULL,
...
  artist int(5) default NULL,
  id     int(8)     NOT NULL auto_increment
);

INSERT INTO albums (name,year,format,artist) values ('Glass Houses','1
+980','lp',123);
INSERT INTO albums (name,format,artist)      VALUES ('Piano Man','45',
+123);
INSERT INTO albums (name,year,format,artist) VALUES ('Back in Black','
+1980','cd',456);