【单选题】下列代码为创建图书视图的代码,请选择所缺少的部分代码。 ( _______________ ) v_book (barcode,bookname,author,price,booktype) ( _______________ ) barcode,bookname,author,price,typename FROM tb_bookinfo AS b ,tb_booktype AS t WHERE b.typeid=t.id;
A. CREATE VIEW 、 AS SELECT B. CREATE VIEW 、 SELECT C. CREATE TABLE 、 AS SELECT D. CREATE TABLE 、 SELECT
A. CREATE VIEW 、 AS SELECT B. CREATE VIEW 、 SELECT C. CREATE TABLE 、 AS SELECT D. CREATE TABLE 、 SELECT
举一反三
- 下列代码为创建图书视图的代码，请选择所缺少的部分代码。 v_book (barcode,bookname,author,price,booktype) barcode,bookname,author,price,typename FROM tb_bookinfo AS b ,tb_booktype AS t WHERE b.typeid=t.id;
- 下面定义视图的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
- 在student表上创建view_stu视图,正确的语句是( )。 A: CREATE VIEW view_stu IS SELECT * FROM student; B: CREATE VIEW view_stu AS SELECT * FROM student; C: CREATE VIEW view_stu SELECT * FROM student; D: CREATE VIEW SELECT * FROM student AS view_stu;
- 在mysql中,创建视图使用( )语句 A: create table B: create view C: select
- 基于表S创建视图R的SQL语句是【 】 A: CREATE R AS SELECT 学号，姓名 FROM S B: CREATE TABLE R AS SELECT 学号，姓名 FROM S C: CREATE VIEW R AS SELECT 学号，姓名 FROM S D: CREATE R FROM SELECT 学号，姓名 AS S