比如： ? 1 2 3 4 UPDATE test.tb_vobile a set a.name = '111 ' WHERE a.id = (select max(id) id from test.tb_vobile) 報錯： ? 1 2 3 4 5 6 7 [SQL]UPDATE test.tb ...
比如：
?| 1 2 3 4 |
UPDATE test.tb_vobile a
set a.name = '111 '
WHERE
a.id = (select max(id) id from test.tb_vobile)
|
報錯：
?| 1 2 3 4 5 6 7 |
[SQL]UPDATE test.tb_vobile a
set a.name = '111 '
WHERE
a.id = (select max(id) id from test.tb_vobile)
|
以下可通過：
?| 1 2 3 4 5 6 7 8 9 10 11 |
UPDATE test.tb_vobile a
join
(select max(id) id from test.tb_vobile) b
on a.id = b.id
set a.name = '123 ';
  更多相關文章
一周排行
 所有分類
|