Hi,

I have the following situation.

CREATE TEMPORARY TABLE T2 ...;
CREATE TEMPORARY TABLE T3 FROM T1 JOIN T2 ON ...;
In the above JOIN, T1 is a permanent table.

UPDATE T3
SET
T1.field = value
WHERE ...;

When I execute the above query there are no errors and mysql indicated 2
rows were changed.

When I examine T1.field in T3 I find it is correctly changed.
When I examine T1.field in T1 it is unchanged.
I expected T1.field in T1 to have the new value.

Any help would be appreciated.

Thank you,
Joe

On 15-10-2011 21:25, Joseph Hesse wrote:
You are updating T3, which is a TEMPORARY TABLE....
so, of course, you are nog seeing your changes in T1

Why would the original change, if the copy is altered?

--
Luuk

On 10/15/2011 02:42 PM, Luuk wrote:
fields.

On 10/15/2011 02:52 PM, Joseph Hesse wrote:
UPDATE T1 JOIN T2 ON ...
SET
T1.field = value
WHERE ...;
Thank you.

How can you possibly have a T1.field *in T3*? Is this some kind
of schizoid column that doesn't know what table it is in? You can
have a T3.field, but it's not a T1.field.

Isn't that a little bit like having a Paris, Texas, USA *in France*?

Where else could T1.field be besides table T1?