If I have a M2M set of tables (so three tables- two with "real" data,
and one binding table in the middle). How do I make copies?

table a: id, column1, column2... column50
table b: id, column1, column2... column50
table c: id, db_a_id, db_b_id

I can't do insert...select because the keys will all be different on
the newly copied tables. So how do I keep the binding in place?

I'm guessing this is a common problem...

I have mysql 5.0.22

dterrors@hotmail.com wrote:
> I can't do insert...select because the keys will all be different on
> the newly copied tables.
Why?