下列( A )可以实现从数据表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;