在tb_name表中创建一个名为name_view的视图,并设置视图的属性为name、pwduser,执行语句是什么?( )
A: CREATE VIEW name_view(name,pwd,user)AS SELECT name.pwd,user FROM tb_mame;
B: SHOW VIEW name_view(name,pwd,user) AS SELECT name,pwd,user FROM tb_mame:
C: DROP VIEW name_view(name,pwd,user) AS SELECT name,pwd,user FROM tb_mame:
D: SELECT * FROM name_view(name,pwd,user) AS SELECT name,pwd,user FROM tb_ name:
A: CREATE VIEW name_view(name,pwd,user)AS SELECT name.pwd,user FROM tb_mame;
B: SHOW VIEW name_view(name,pwd,user) AS SELECT name,pwd,user FROM tb_mame:
C: DROP VIEW name_view(name,pwd,user) AS SELECT name,pwd,user FROM tb_mame:
D: SELECT * FROM name_view(name,pwd,user) AS SELECT name,pwd,user FROM tb_ name:
举一反三
- 下列哪些SQL语句可以查询出User表中name为张三的记录（）。 A: SELECT * FROM User WHERE name = ’张三’ B: SELECT * FROM User WHERE name = ’张三’ LIMIT 0，1 C: SELECT * FROM User WHERE name LIKE ’张三’ D: SELECT * FROM User WHERE name LIKE ’%张三%’
- 【多选题】下面语句可以实现查询user表中“zhangsan”的user,password,logins信息的是 A. select logins,user,password from user where name like ’%zhangsan%’; B. select user,password,logins, from user where name like ’zhangsan’; C. select password,logins,user from user where name=’zhangsan’ limit 1; D. select user,password,logins from user where name=’zhangsan’;
- 下面定义视图的SQL语句，哪一个是错误的？（ ） A: create view VIEW1 as select id,name,sex from users B: create view VIEW2 as select count(*) as studentTotal,classname from student C: create view VIEW3 as select name,price from D: create view VIEW4 as select logdate,price,1.1*parice as ‘涨价’ from shop
- 下面哪个是错误的助手函数view调用？ A: return view("",["name"=>$myname,"id"=>$myid]); B: return view("",["name"=>myname]); C: return view("user/login"); D: return view("");
- 在HBase中，创建一张名为“user_c”的表，该表有一个名为“User”的列族，其相应Shell命令应该是（）。 A: create‘user_c’,{name=>‘User’}; B: create{‘user_c’=>‘User’}; C: create‘user_c’,{NAME=‘User’}; D: create‘user_c’,{NAME=>‘User’};