Tfe

Ongi etorri tfe-ren webgunera...

Old stuff/ecole_etude_fac_de_pau/licence_2/bd/insert.sql

(Deskargatu)
insert into interprete values ('I000','Cali','solo','');

insert into album values ('A000','l''amour parfait','20/01/2003','fcn','variété','I000');

insert into chanson values ('C000','c''est quand le bonheur','Cali','Cali',291);
insert into chanson values ('C001','elle m''a dis','Cali','Cali',193);
insert into chanson values ('C002','pensons à l''avenir','Cali','Cali',262);

insert into compose values ('A000','C000',1);
insert into compose values ('A000','C001',2);
insert into compose values ('A000','C002',3);





insert into interprete values ('I001','Henri Des','solo','');

insert into album values ('A001','Cache-cache','20/02/1977','universel','variété','I001');

insert into chanson values ('C003','mon gros loup mon ptit loup','Henri Des','Henri Des',137);
insert into chanson values ('C004','la feuille et l''écureuil','Henri Des','Henri Des',104);
insert into chanson values ('C005','les petits canards','Henri Des','Henri Des',87);

insert into compose values ('A001','C003',1);
insert into compose values ('A001','C004',2);
insert into compose values ('A001','C005',3);




insert into interprete values ('I002','mickey3d','solo','');

insert into album values ('A002','Tu vas pas mourir de rire','20/02/2002','universel','variété','I002');

insert into chanson values ('C006','amen','mickey3d','mickey3d',188);
insert into chanson values ('C007','respire','mickey3d','mickey3d',205);
insert into chanson values ('C008','mimoun fils de harki','mickey3d','mickey3d',171);

insert into compose values ('A002','C006',1);
insert into compose values ('A002','C007',2);
insert into compose values ('A002','C008',3);