下列代码为创建图书视图的代码，请选择所缺少的部分代码。 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;
举一反三
- 【单选题】下列代码为创建图书视图的代码,请选择所缺少的部分代码。 ( _______________ ) 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
- 查询图书名称含有“程序”的图书信息。语句如下：SELECT BookCode, BookName, Author, Price, DiscountFROM BookWHERE BookName LIKE ________
- BookStore数据库中有图书表 Book(BookCode, BookName, Author, PublisherCode, PublishTime，BookSort, ISBN, BookPicture, ContentInro, Price, Discount) 查询图书名称（BookName）含有“程序”的图书信息。SQL语句: SELECT BookCode,BookName,Author,Price,Discount FROM Book WHERE Name=“%程序%”
- BookStore数据库中有图书表 Book(BookCode, BookName, Author, PublisherCode, PublishTime，BookSort, ISBN, BookPicture, ContentInro, Price, Discount) 查询作者名长度大于等于8的图书信息,显示书名(BookName)及作者(Author)。SQL语句: SELECT BookName, Author FROM Book WHERE Lenth(Author)= 8
- 查询作者名长度大于等于8的图书信息，显示书名（BookName）及作者（Author）。语句如下：SELECT BookName, AuthorFROM BookWHERE Len(Author)_________