cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

jamesava
Member
0 REPLIES 0