use admin_mysql;

CREATE VIEW admin_mysql.vue AS SELECT compte FROM admin_mysql.banque;

REVOKE select ON *.* FROM 'michel'@'localhost';

GRANT SELECT ON admin_mysql.vue TO 'michel'@'localhost';
select * from mysql.user;
delete from mysql.user where user='michel';

update banque set compte="ok";
select * from banque;
show  table status;
show open tables;
show create table banque;

select * from produits;
update produits set nom_p="ok";




lock table table_lecture write, table_insert write;
insert into table_lecture select * from table_insert;


select high_priority * from produits;

show processlist;