1.通过查询的结果更新表中某数据
update invitation set lastposter = (select usre_name from users where users.userid = '1') where invitation.invitationid='1';
在invitation.invitationid='1',更新invitation.lastposter值为查询结果
1.通过查询的结果更新表中某数据
update invitation set lastposter = (select usre_name from users where users.userid = '1') where invitation.invitationid='1';
在invitation.invitationid='1',更新invitation.lastposter值为查询结果