update test set source=11 where md5= (select md5 from test where source=18 limit 0,1)
报错,You can't specify target table 'test' for update in FROM clause
这个怎么解决
...全文
2153打赏收藏
问个sql语句
update test set source=11 where md5= (select md5 from test where source=18 limit 0,1) 报错,You can't specify target table 'test' for update in FROM clause 这个怎么解决