How to insert values into an MYSQL-Table by using Select-Statements

Question

Okay, This one is pretty simmilar to my last one, but I don't get it...!

I am trying the following:

Insert into table b
  (Select column_1 from table_a where ID = 1),
  (Select column_2 from table_a where ID = 1),
  0,
  (Select column_3 from table_a where ID = 1);

But I always get a syntax-error...! I think it's quite logical what I'm trying to do.

Greetz from Germany and thx for your answers!

Answer 1

Very close - use:

INSERT INTO TABLE_B
SELECT column_1, column_2, column_3 
  FROM TABLE_A
 WHERE id = 1

..assuming there are only three columns in TABLE_B. Otherwise, specify the columns being inserted into:

INSERT INTO TABLE_B
  (column_1, column_2, column_3)
SELECT column_1, column_2, column_3 
  FROM TABLE_A
 WHERE id = 1

And, if need be--you can use statically defined values as well:

INSERT INTO TABLE_B
  (column_1, column_2, column_3, column_4)
SELECT column_1, column_2, 0, column_3 
  FROM TABLE_A
 WHERE id = 1