A.DEFINER B.UNDEFINED C.WITH CHECK OPTION D.SQL SECURITY
A.創(chuàng)建v_goods的用戶默認(rèn)為當(dāng)前用戶 B.視圖算法由MySQL自動(dòng)選擇 C.視圖的安全控制默認(rèn)為DEFINER D.以上說法都不正確
下列代碼為創(chuàng)建圖書視圖的代碼,請(qǐng)選擇所缺少的部分代碼。() ()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、ASSELECT B.CREATE VIEW、SELECT C.CREATE TABLE、ASSELECT D.CREATE TABLE、SELECT