Click here to Skip to main content
15,072,267 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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?
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900