Travaux PratiquesTP1 - création de contenu

describe personnel;
describe societe;
describe transaction;

insert into societe2 select * from societe ;

create table societe2 (scnum int primary key,scnom varchar(20) not null, ca int ,localisation varchar(20) not null);

create table personnel_paris AS select * from personnel where ville='paris' ;

update personnel _paris set salaire=salaire*1.1 ;

update transaction set heuredep=heuredep+100,heurearr=heurearr+100 where villedep='aurillac' ;

update personnel set ville='paris' where plnom='reichstadt' ;
insert into personnel _paris select * from personnel where plnom='reichstadt' ;

delete from societe2 where scnom='a3' ;

alter table societe2 add(nb_employe int) ;
update societe2 set nb_employe=(select count(distinct plnum) from transaction where transaction.scnum=societe2.scnum) ;

update personnel set ville=null where plnom='Devlieger';