将表table_a中的字段fieldA、fieldB、fieldC的内容写入table_B中字段fieldA、fieldB、fieldC，应该怎样写？？

Question

insert into table_B (ieldA,fieldB,fieldC)
select fieldA,fieldB,fieldC from table_a

Answer 1

insert into table_B (ieldA,fieldB,fieldC)
select fieldA,fieldB,fieldC from table_a

Answer 2

insert into table)B(fieldA,fieldB,fieldC) select table_a.fielda,table_a.fieldb,table_a.fieldc from table_a

Answer 3

insert table_B (fieldA,fieldB,fieldC) select fieldA,fieldB,fieldC from table_a

Answer 4

insert into table_B(fieldA,fieldB,fieldC) select fieldA,fieldB,fieldC from table_a

Answer 5

SELECT [select_list] INTO {:hvar [,...]} select_optionsSELECT au_lname INTO :name FROM authors WHERE stor_id=:id

Answer 6

insert into table_B (ieldA,fieldB,fieldC)
select fieldA,fieldB,fieldC from table_a