Insert/Update MySql table by Select from another Table C#

See more:

C#

Hi,

I am trying to do an Insert Statement and Update statement on one table, table1 from the data from another table, table2 (using Select * from table2).
is there a way to do dynamically do the Insert/Update on table2 from Select * from table1 without having to specify all the columns of table1 in the Insert/Update statements, since there are many columns in each and I do this procedure for more than one pair of tables(table1, table2).

I use MySql database and write code on C#.
Any help please?