On 07.02.2008 03:52 CE(S)T, Chris wrote:
If you don't mind a mysql-specific fix, and can get the data you want
from a select query you could:
insert into table (select goes here) on duplicate key update;
or maybe a replace into ?
INSERT/REPLACE ... SELECT will always overwrite the entire
On 06.02.2008 08:12 CE(S)T, Chris wrote:
Yves Goergen wrote:
My goal was to copy some potentially large BLOB from one record to
another in the same table
Update table set blob2_field=blob1_field;
This does something totally different. ;) See my first posting why.
--
Yves Goergen
-Original Message-
From: Yves Goergen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 05, 2008 6:22 PM
To: Baron Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Error: You can't specify target table '...' for update in
FROM clause
On 05.02.2008 23:25 CE(S)T, Baron Schwartz wrote
Yves Goergen wrote:
On 06.02.2008 08:12 CE(S)T, Chris wrote:
Yves Goergen wrote:
My goal was to copy some potentially large BLOB from one record to
another in the same table
Update table set blob2_field=blob1_field;
This does something totally different. ;) See my first posting why.
Ah
Hi,
I've got an error message from MySQL 5.0 that I don't understand.
UPDATE message_revision SET HasData = 1, Data = (SELECT Data
FROM message_revision WHERE MessageId = 7 AND RevisionNumber = 5)
WHERE MessageId = 7 AND RevisionNumber = 6
SQL error: [SQLSTATE:HY000, 1093] You can't specify
Hi,
On Feb 5, 2008 11:26 AM, Yves Goergen [EMAIL PROTECTED] wrote:
Hi,
I've got an error message from MySQL 5.0 that I don't understand.
UPDATE message_revision SET HasData = 1, Data = (SELECT Data
FROM message_revision WHERE MessageId = 7 AND RevisionNumber = 5)
WHERE MessageId = 7 AND
On 05.02.2008 23:25 CE(S)T, Baron Schwartz wrote:
You can't select from a table you're updating at the same time. What
at the same time means is a bit unclear unless you're one of the
MySQL developers ;-)
Yes, Paul DuBois already replied to me off-list. Now I found that
documentation part
Yves Goergen wrote:
On 05.02.2008 23:25 CE(S)T, Baron Schwartz wrote:
You can't select from a table you're updating at the same time. What
at the same time means is a bit unclear unless you're one of the
MySQL developers ;-)
Yes, Paul DuBois already replied to me off-list. Now I found that