Азбука MySQL

Shell> tar -zxf gunzip mysql-3.23.49a-pc-linux-gnu-i686.tar.gz 

Shell>cd /usr/local/mysql
Shell>scripts/mysql_install_db

MY_BASEDIR_VERSION=$MY_PWD # Where libexec, share and var are
ledir=$MY_BASEDIR_VERSION/bin # Where mysqld is
DATADIR=$MY_BASEDIR_VERSION/data
else
MY_BASEDIR_VERSION=/usr/local/mysql
DATADIR=/usr/local/mysql/data
ledir=/usr/local/mysql/bin 

use audio_cd;
create table cd ( cd_id SMALLINT unsigned not null auto_increment PRIMARY KEY, name VARCHAR(100) not null default "", release_year YEAR
);
create table songs( song_id SMALLINT unsigned not null auto_increment, primary key (song_id), song_name VARCHAR(200) not null default "", autor_name VARCHAR(100) not null default "", description VARCHAR(255) not null default ""
);
create table songs_on_cd( cd_id SMALLINT unsigned not null REFERENCES cd, song_id SMALLINT unsigned not null REFERENCES songs
);
create table people( p_id SMALLINT unsigned not null auto_increment PRIMARY KEY, name VARCHAR(100) not null default "", addr VARCHAR(255) not null default "", phonnum char(6) not null default "000000", email varchar(50) not null default ""
);
create table take_disk( cd_id SMALLINT unsigned not null REFERENCES cd, p_id SMALLINT unsigned not null REFERENCES people
); 

mysql> insert into songs values (NULL, "The post war dream", "Pink Floyd", ""), (NULL, "Your possible pasts", "Pink Floyd",""), (NULL, "One of the few", "Pink Floyd",""), (NULL, "The hero's return", "Pink Floyd",""), (NULL, "The gunner's dream", "Pink Floyd",""), (NULL, "Paranoyd eyes", "Pink Floyd",""), (NULL, "Get your filthy hands off my desert", "Pink Floyd",""), (NULL, "The fletcher memorial home", "Pink Floyd",""), (NULL, "Southampton dock", "Pink Floyd",""), (NULL, "The final cut", "Pink Floyd",""), (NULL, "Hot now john", "Pink Floyd",""), (NULL, "Two suns in the sunset", "Pink Floyd","");