select from one table and insert into another

Question

I've got two tables.

Table_A (nid, vid, type, title, uid)

Table_B (id, questiontext)

I need to insert records from Table_B into Table_A. I tried this:

INSERT INTO Table_A (nid, vid, type, title, uid) VALUES ('', '', multichoice', (SELECT questiontext from Table_B), '1') 

but it's throwing an error.

What should be the correct statement?

UPD: I should add that nid is autoincrement and the value of vid should be same as nid.

Answer 1

Have you tried

INSERT INTO Table_A (nid, vid, type, title, uid)  SELECT  '',          '',          'multichoice',          questiontext ,         '1' from    Table_B 

Have a look at INSERT ... SELECT Syntax

Answer 2

You should use the following SQL query:

INSERT INTO Target(A, B, C)   SELECT A, B, C     FROM Source