|
|
|
|
||||||
![]() |
|
|
LinkBack | Outils de la discussion |
|
|
#1 |
|
Messages: n/a
Hébergeur: |
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 |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
dterrors@hotmail.com wrote:
> I can't do insert...select because the keys will all be different on > the newly copied tables. Why? |
|
![]() |
| Outils de la discussion | |
|
|