check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM
sql语句:
UPDATE sys_user SET PASSWORD=b.password,pwd=b.pwd FROM
(SELECT PASSWORD ,PWD,uid FROM test_user) b WHERE id=b.uid;
------解决思路----------------------
mysql 应该可以尝试这个方式
UPDATE sys_user,test_user
SET sys_user.PASSWORD=test_user.PASSWORD
,sys_user.pwd=test_user.pwd
WHERE sys_user.id=test_user.uid;