On Nov 30, 2007 10:00 PM, tedd <tedd.sperling@xxxxxxxxx> wrote: > 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 > > It actually sounds like they may have downgraded. MySQL 4.x and 5.x shouldn't have a problem with the query, but 3.23 probably won't do it properly. If it's a cPanel host, they may have an old version of cPanel still running on the server, which would include the 3.23 option. If that is, in fact, the case.... jump ship. This will only be the first of many problems. And on a side note, wasn't 3.23 the first REAL stable version of MySQL accepted at large for production use? I think I recall playing around with 2.x, but it seems to me that, for the longest time, everyone was on 3.23. Am I perhaps simply having a premature senior moment? Happy December, by the way. -- Daniel P. Brown [office] (570-) 587-7080 Ext. 272 [mobile] (570-) 766-8107 If at first you don't succeed, stick to what you know best so that you can make enough money to pay someone else to do it for you. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
