MySQL＃1093 - 您可以't specify target table ' giveaways'在FROM子句中进行更新

6 回答

• 28

  这是因为您的更新可能是周期性的...如果更新该记录会导致某些事情发生，导致 WHERE 条件 FALSE ？你知道那不是't the case, but the engine doesn' . 在操作中桌面上也可能存在相反的锁定 .

  我认为你可以这样做（未经测试）：

  UPDATE
      giveaways
  SET
      winner = '1'
  ORDER BY
      id DESC
  LIMIT 1
  

  Read more

  回复于 2024-05-05T13:49:08+08:00
• 0

  基于您链接到此文章的文章中的信息应该有效：

  update giveaways set winner='1'
  where Id = (select Id from (select max(Id) as id from giveaways) as t)
  

  回复于 2024-05-05T13:49:08+08:00
• 0

  update giveaways set winner=1 
  where Id = (select*from (select max(Id)from giveaways)as t)
  

  回复于 2024-05-05T13:49:08+08:00
• 37

  create table GIVEAWAYS_NEW as(select*from giveaways);
  
  update giveaways set winner=1
  where Id=(select max(Id)from GIVEAWAYS_NEW);
  

  回复于 2024-05-05T13:49:08+08:00
• 13

  利用TEMP TABLE：

  如下：

  UPDATE TABLE_NAME SET TABLE_NAME.IsActive=TRUE
  WHERE TABLE_NAME.Id IN (
      SELECT Id
      FROM TEMPDATA
  );
  
  CREATE TEMPORARY TABLE TEMPDATA
  SELECT MAX(TABLE_NAME.Id) as Id
  FROM TABLE_NAME
  GROUP BY TABLE_NAME.IncidentId;
  
  SELECT * FROM TEMPDATA;
  
  DROP TABLE TEMPDATA;
  

  回复于 2024-05-05T13:49:08+08:00
• 0

  您可以先创建子查询的视图，然后从视图中选择更新/删除 . 只需记住删除视图 .

  回复于 2024-05-05T13:49:08+08:00