把Student表 的INSERT权限从用户王平处收回用SQL语句描述为REVOKE INSERT ON Student FROM 王
A、grant select,update,insert on course.student for ‘xiaowang@localhost’;
B、grant select,update,insert on course.student to ‘xiaowang@localhost’;
C、grant ‘xiaowang@localhost’ to select,update,insert for course.student;
D、grant ‘xiaowang@localhost’ to course.student on select,update,insert;
补充语句,把对Student表和Course表的全部操作权限授予用户U1和U2:
GRANT______
ON TABLE Student,Course
TO U1,U2
A、create database userdb;//创建数据库userdb
B、create table if not exists usr(id bigint,name string,age int);//如果usr表不存在,创建表usr,含三个属性id,name,age
C、load data local inpath ‘/usr/local/data’ overwrite into table usr; //把目录’/usr/local/data’下的数据文件中的数据以追加的方式装载进usr表
D、insert overwrite table student select * from user where age>10; //向表usr1中插入来自usr表的age大于10的数据并覆盖student表中原有数据
A、INSERT INTO Student(“id”,”name”) VALUES(1,”小王”)
B、INSERT INTO Student(id,name) VALUES(1,’小王’)
C、INSERT INTO Student VALUES(1,”小王”)
D、INSERT INTO Student(id,”name”) VALUES(1,”小王”)
A、insert into Student(sno,sname,sage) values('201530','Jakc',18)
B、insert into Student(sno,sname) values('201530','Jakc')
C、insert into Student values('201530','Jakc')
D、insert into Student values('201530','Jakc',18)
A、add into student values('d001' , '王明' , '女' , 18)
B、add student values('d001' , '王明' , '女' , 18)
C、insert student values('d001' , '王明' , '女' , 18)
D、insert into student values(d001 , 王明 , 女 , 18)
创建测试数据 学生表 Student create table Student(SId varchar(10),Sname varchar(10),Sage datetime,Ssex varchar(10)); insert into Student values('01' , '赵雷' , '1990-01-01' , '男'); insert into Student values('02' , '钱电' , '1990-12-21' , '男'); insert into Student values('03' , '孙风' , '1990-05-20' , '男'); insert into Student values('04' , '李云' , '1990-08-06' , '男'); insert into Student values('05' , '周梅' , '1991-12-01' , '女'); insert into Student values('06' , '吴兰' , '1992-03-01' , '女'); insert into Student values('07' , '郑竹' , '1989-07-01' , '女'); insert into Student values('09' , '张三' , '2017-12-20' , '女'); insert into Student values('10' , '李四' , '2017-12-25' , '女'); insert into Student values('11' , '李四' , '2017-12-30' , '女'); insert into Student values('12' , '赵六' , '2017-01-01' , '女'); insert into Student values('13' , '孙七' , '2018-01-01' , '女');
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!