视图

一.视图

1.创建

create view emp_view as (select id ,name from employee);

2.查看

select * from emp_view

3.修改

update emp set name='司法' where id=3；

4.删除

delete from emp where id =3;

二.序列

1.创建

create sequence emp_seq increment by 1

start with 1

maxvalue 999999

2.获取emp_seq的下一个值

select emp_seq.nextval from emp;

获取emp_seq 当前值

select emp_seq.currval from emp;

3.作为id插入表

insert into emp（id,name) values (emp_seq.nextval,‘张三');

三.用户

1.创建

create user 'username' @ 'host' identified by 'password';

2.授权

grant  select ,insert on test.user to 'pig' @ '%';

3.设置或者修改密码

set password for  'username' @ 'host' =password ('new password‘）；

4.撤销权限

revoke select  on *.* from 'pig' @'%';

5.删除用户

drop user 'username' @ 'host';