CREATE TABLE artists (
first_name text default NULL,
last_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,
year int(4) default NULL,
format enum('lp','cassette','cd','45'),
artist int(5) default NULL,
id int(8) NOT NULL auto_increment
);
##
##
INSERT INTO albums (name,year,format,artist) values ('Glass Houses','1980','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);