use admin_mysql;

select * from banque;

-- alter table banque add prénom varchar(150) not null; 

update banque set prénom ='Maria' where compte='Mme Wayne';
update banque set prénom ='Jim' where compte='Vendeur';

select * from banque;
drop view if exists banqueVue;

CREATE DEFINER=root@localhost SQL SECURITY DEFINER VIEW banqueVue 
AS select banque.compte AS Nom, banque.prénom AS Pré from banque;

show create view banqueVue;

select * from banqueVue;
