mysql - 使用子查询删除 MySQL

Question

我正在尝试使用同一个表“carretilla”的子查询来删除这适用于 SQL Server

DELETE FROM carretilla 
WHERE carcod IN (
  SELECT carcod  
  FROM carretilla 
  WHERE TIMESTAMPDIFF(MINUTE,carfch, NOW()) > 10 
  group BY carcod
);

我该怎么做？谢谢

Answer 1

据我所知，您无法直接引用从中删除或更新的表，但如果您使用子查询，服务器将创建一个临时记录集并让您执行删除操作，因此这应该可行:

DELETE FROM carretilla 
WHERE carcod IN (
  SELECT carcod FROM (
    SELECT carcod  FROM carretilla 
    WHERE TIMESTAMPDIFF(MINUTE,carfch, NOW()) > 10 group BY carcod
  ) temp_table
);

查看此sample SQL Fiddle .