比如: UPDATE test.tb_vobile a set a.name = '111 ' WHERE a.id = (select max(id) id from test.tb_vobile) 报错: [SQL]UPDATE test.tb_vobile a set a.name = '111 ' WHERE a.id = (select max(id) id from test.tb_vobile) 以下可通过: UPDATE test.tb_vobile a join (select max(id) id
