How do I copy records and their relational records too?

#1

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

dterrors (AT) hotmail (DOT) com wrote:

Quote:

I can't do insert...select because the keys will all be different on
the newly copied tables.
Why?

#3

dterrors (AT) hotmail (DOT) com wrote:

Quote:

I can't do insert...select because the keys will all be different on
the newly copied tables.
Why?

#4

dterrors (AT) hotmail (DOT) com wrote:

Quote:

I can't do insert...select because the keys will all be different on
the newly copied tables.
Why?

#5

On Feb 4, 4:55 pm, "Paul Lautman" <paul.laut... (AT) btinternet (DOT) com> wrote:

Quote:

dterr... (AT) hotmail (DOT) com wrote:
I can't do insert...select because the keys will all be different on
the newly copied tables.

Why?

Because I'm copying records. So therefore their keys will be
different. Unique keys? Two records can't have the same key?

#6

On Feb 4, 4:55 pm, "Paul Lautman" <paul.laut... (AT) btinternet (DOT) com> wrote:

Quote:

dterr... (AT) hotmail (DOT) com wrote:
I can't do insert...select because the keys will all be different on
the newly copied tables.

Why?

Because I'm copying records. So therefore their keys will be
different. Unique keys? Two records can't have the same key?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How do I copy records and their relational records too?

comp.databases comp.databases

How do I copy records and their relational records too? - 02-04-2008 , 04:54 PM

Re: How do I copy records and their relational records too? - 02-04-2008 , 04:55 PM

Re: How do I copy records and their relational records too? - 02-04-2008 , 04:55 PM

Re: How do I copy records and their relational records too? - 02-04-2008 , 04:55 PM

Re: How do I copy records and their relational records too? - 02-04-2008 , 04:58 PM

Re: How do I copy records and their relational records too? - 02-04-2008 , 04:58 PM