How can i copy all data from table1 to table2, There is lots of columns, not a same number?

jamesava — Fri, 23 Apr 2021 06:25:28 GMT

I have a table1 with roughly 40 columns. I have created table2 like table1 but included few more columns. That is because I have 4 tables like table1 and now want to combine them all into one table, table2.

If I try INSERT INTO table2 SELECT * FROM table1

I get the error that column numbers are not the same. Is there a question to do this thing without writing all of the columns?

Thank you

Bazoocam omegle tv

topic How can i copy all data from table1 to table2, There is lots of columns, not a same number? in Integration and Testing

How can i copy all data from table1 to table2, There is lots of columns, not a same number?