计算机二级mysql操作题答案（15套全）

第1套

insert into tb_dept(deptno,dname,manager,telephone) values('D4','公关部','Liming','010-82953306');

alter table tb_employee alter column salary set default '3500';

select count(*) as '总人数' from tb_employee where deptno=(select deptno from tb_dept where dname='销售部');

create view v_emp as select eno,ename,age,salary from tb_employee where deptno=(select deptno from tb_dept where dname='采购部');

create user 'Yaoming'@'localhost' identified by'abc123';

第2套 

select sum(price) as total from tb_commodity where cname='电视机' and origin='北京';

alter table tb_commodity drop column desc1;

insert into tb_commodity(cname,ctype,origin,birth,price) values('钢笔','文具','上海','2012-12-25',25);

create view v_bjcommodity as select * from tb_commodity where origin='北京';

create user 'client'@'localhost';

grant select(cno,cname) on tb_commodity to 'client'@'localhost' with grant option;

 第3套

alter table tb_student add column ssex char(1) default 'M';

update tb_student set smajor='计算机' where sno='100';

create view v_avg(cname,caverage) as select cname,avg(grade) from tb_score group by cname;

alter table tb_student add unique index idx_stu(sno);

create user 'newuser'@'localhost';

grant select on tb_student to 'newuser'@'localhost' with grant option;