_id i
-Original Message-
From: Philippe Poelvoorde
To: Victor Pendleton
Cc: ''[EMAIL PROTECTED] ' '
Sent: 7/27/04 9:56 AM
Subject: Re: Replication script pb
I feed the table with :
INSERT INTO table ( SELECT @backup_id, col1. col2 FROM table_to_backup)
How can i do w
: ''[EMAIL PROTECTED] ' '
Sent: 7/27/04 9:56 AM
Subject: Re: Replication script pb
I feed the table with :
INSERT INTO table ( SELECT @backup_id, col1. col2 FROM table_to_backup)
How can i do with a temp table ?
Victor Pendleton wrote:
> Ugly, but you could try using a
EMAIL PROTECTED] '
Sent: 7/27/04 5:54 AM
Subject: Re: Replication script pb
Paul DuBois wrote:
At 8:20 -0500 7/26/04, Victor Pendleton wrote:
Have you tried using the last insert id function instead?
SET @backup_id = last_insert_id()
That'll give him the same result. I suspect the problem mig
At 11:54 +0100 7/27/04, Philippe Poelvoorde wrote:
Paul DuBois wrote:
At 8:20 -0500 7/26/04, Victor Pendleton wrote:
Have you tried using the last insert id function instead?
SET @backup_id = last_insert_id()
That'll give him the same result. I suspect the problem might be
that user variables are
Ugly, but you could try using a temp table to store the last_insert_id().
-Original Message-
From: Philippe Poelvoorde
To: '[EMAIL PROTECTED] '
Sent: 7/27/04 5:54 AM
Subject: Re: Replication script pb
Paul DuBois wrote:
> At 8:20 -0500 7/26/04, Victor Pendleton wrote:
&
Paul DuBois wrote:
At 8:20 -0500 7/26/04, Victor Pendleton wrote:
Have you tried using the last insert id function instead?
SET @backup_id = last_insert_id()
That'll give him the same result. I suspect the problem might be
that user variables are not replicated well in MySQL 4.0.x.
Yes, same erro
At 8:20 -0500 7/26/04, Victor Pendleton wrote:
Have you tried using the last insert id function instead?
SET @backup_id = last_insert_id()
That'll give him the same result. I suspect the problem might be
that user variables are not replicated well in MySQL 4.0.x.
Philippe, what version of MySQL ar
Have you tried using the last insert id function instead?
SET @backup_id = last_insert_id()
-Original Message-
From: Philippe Poelvoorde
To: [EMAIL PROTECTED]
Sent: 7/26/04 7:03 AM
Subject: Replication script pb
Hi,
We have an environnment with a master and a slave. We run a script every
