Thanks for the answer but that's not it. It was my typo. I am really updating
and selecting from the same table.
--
Malka Cymbalista
Webmaster, Weizmann Institute of Science
[EMAIL PROTECTED]
08-934-3036
>>> On 4/9/2008 at 1:54 PM, in message
<[EMAIL PROTECTED]>, "Edward Kay"
<[EMAIL PROTECT
> We have just moved to a new web server where we are running mysql
> version: 5.0.45
> On the old machine, when we gave the following command:
> update table1 set passwd = password('xx') where user_name="xx";
Here you're updating 'table1'...
> and then gave the following command,
> SELECT us
