下列（ ）可以实现从数据表tb_book中查询publishid和typeid字段的值，插入到数据表tb_book2中。
A: INSERT INTO tb_book2(publishid,typeid) SELECT publishid, typeid FROM tb_book;
B: INSERT FROM tb_book2(publishid,typeid) SELECT publishid, typeid FROM tb_book;
C: INSERT INTO FROM tb_book2(publishid,typeid) SELECT publishid, typeid FROM tb_book;
D: INSERT INTO tb_book(publishid,typeid) SELECT publishid, typeid FROM tb_book2;
A: INSERT INTO tb_book2(publishid,typeid) SELECT publishid, typeid FROM tb_book;
B: INSERT FROM tb_book2(publishid,typeid) SELECT publishid, typeid FROM tb_book;
C: INSERT INTO FROM tb_book2(publishid,typeid) SELECT publishid, typeid FROM tb_book;
D: INSERT INTO tb_book(publishid,typeid) SELECT publishid, typeid FROM tb_book2;
举一反三
- 下列（）可以实现从数据表tb_book中查询publishid和typeid字段的值，插入到数据表tb_book2中。
- 查询book表中book_name字段和book_price字段的信息，查询语句是 A: select book_name，book_price from book B: select * from book C: select book from book_name，book_price D: select * from book book_name，book_price
- 查询book表中price字段的最大值，查询语句是： A: select max(price) from book； B: select min(price) from book； C: select price from min book； D: select price from max book；
- 智慧职教: 更新borrow表每条借书记录的eprdate(到期日期)。 borrow eprdate=timestampadd(day,(select maxdays from readertype where typeID in (select typeID from reader where reader.readerID=.)),brwdate);
- 【单选题】设有表TA(a,b,c)和表TB(c,d),其中字段c为关联两表的同名公共字段。 欲查询两表中的所有记录,正确的SQL语句是()。 A. Select * From TA,TB B. Select a,b,c,d From TA,TB; Where TA.c=TB.c C. Select TA.a,TA.b,TA.c,TB.d From TA,TB: Inner Join TA.c=TB.c D. Select a,b,TA.c,d From TA,TB; Where TA.c=TB.c