update p
set p.username=a.name
from pre_ucenter_members p ,aa a
where p.ygno=a.ygno and p.ygno='0'#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from pre_ucenter_members p ,aa a
where p.ygno=a.ygno and p.ygno='0'' at line 3 请问大家知道是什么出错吗?在线等。谢谢
set pre_ucenter_members.username=aa.name
where pre_ucenter_members.ygno=aa.ygno and pre_ucenter_members.ygno='0'
set p.username=a.name
where p.ygno=a.ygno and p.ygno='0'
set p.username=a.name
where p.ygno=a.ygno and p.ygno='0'
MYSQL语法略有不同。
set p.username=a.name
where p.ygno=a.ygno and p.ygno='0'