insert data from one table to another in mysql

Question

i want to read all data from one table and insert some data in to another table. my query is

  INSERT INTO mt_magazine_subscription (        magazine_subscription_id,        subscription_name,        magazine_id,        status )    VALUES (        (SELECT magazine_subscription_id,                subscription_name,                magazine_id         FROM tbl_magazine_subscription         ORDER BY magazine_subscription_id ASC), '1') 

but i got an error that

  #1136 - Column count doesn't match value count at row 1 

please help me.

Answer 1

You can use INSERT...SELECT syntax. Note that you can quote '1' directly in the SELECT part.

INSERT INTO mt_magazine_subscription (        magazine_subscription_id,        subscription_name,        magazine_id,        status )  SELECT magazine_subscription_id,         subscription_name,         magazine_id,         '1' FROM tbl_magazine_subscription ORDER BY magazine_subscription_id ASC