Moving data from one tbl to another

[kschuster]

using mysql.

I'm in the process of combining sever tables into one.

what would the sql look like to move the content of one table to another?

Thanks
Keith

[zhabala]

I am not sure if it is what you want, but you can write

INSERT INTO table1 ( column1, column2, column3 ) SELECT columnA, columnB, columnC FROM tableX

It will COPY records from tableX to table1 from particular columns into particular columns.

Zdenek