> 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]
