At 2:00 PM +1100 11/30/07, Chris wrote:
Out of curiosity, what SQL server (and version) are you using? I
currently have MySQL 5.0.33 on my dev box and I had no problem with the
query I gave you. Perhaps it's a version issue. There really shouldn't
be a problem updating a table that also occurs in the select query since
the select query should take place before the insert.
He wasn't doing an insert/select, he was doing an update with two
tables joined together.
<copy>
I thought that --
UPDATE user1 u1, user2 u2
SET u1.login = u2.login, u1.password = u2.password
WHERE u1.username = u2.username
-- would work, but it don't.
Yes, that was true. But considering that it no longer worked, I moved
on. I still have no clue as to why four months ago the code ran and
now it doesn't -- other than the host upgraded. But, I don't see how
that could have affected things.
As for MySQL version, it's now 3.23.58 -- but I don't know what it
was before the upgrade -- could have been the same. I dunno.
Thanks for the interest.
Cheers,
tedd
--
-------
http://sperling.com http://ancientstones.com http://earthstones.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
