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 PROTECTED]> wrote:
>> 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 user_name FROM alon_protein_passwd WHERE (user_name = "xx"
>> AND passwd=password('xx'))
>
> ..but here you're selecting from 'alon_protein_passwd'
>
>> we got the expected results.
>>
>> Now when we do this, on the new machine, we get no result i.e. Empty set.
>>
>> Any help will be appreciated.
>>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
