???????磺
????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 from test.tb_vobile) b
????on a.id = b.id
????set a.name = '123 ';
??????
????UPDATE test.tb_vobile a ??(select max(id) id from test.tb_vobile) b
????set a.name = '321 '
????WHERE
????a.id = b.id ;
?????????
????1??update ??????μ???????set??where????????????
????2??update ??????????????и??￡?sqlserver???У???
?????磺update ta a??tb b set a.Bid=b.id ??b.Aid=a.id;
????3??update ?????????????????????????????from??
????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)
????[Err] 1093 - You can't specify target table 'a' for update in FROM clause
??????????????
????UPDATE test.tb_vobile a
????join
????(select max(id) id from test.tb_vobile) b
????on a.id = b.id
????set a.name = '123 ';
??????
????UPDATE test.tb_vobile a ??(select max(id) id from test.tb_vobile) b
????set a.name = '321 '
????WHERE
????a.id = b.id ;
?????????
????1??update ??????μ???????set??where????????????
????2??update ??????????????и??￡?sqlserver???У???
?????磺update ta a??tb b set a.Bid=b.id ??b.Aid=a.id;
????3??update ?????????????????????????????from??