mysql 无法在 FROM 子句中指定更新目标表

Question

我必须检查一些不需要的记录并将其删除，因为我在下面的查询中使用了这些记录

delete from contain_tab 
where org_id = "RTY" 
      AND id_contain 
           NOT IN (
               select id_contain from(
                  SELECT id_contain FROM contain_tab c 
                  WHERE org_id = "RTY" 
                  AND (c.cu_date,c.cv_date) 
                  in(
                       select max(cu_date),max(cv_date) from contain_tab cs 
                       where org_id = "RTY" 
                       AND cs.container = c.container 
                       and cs.mfest_id = c.mfest_id 
                       and cs.sl_number = c.sl_number)
                     ) 
              as id_contain)

结构

CREATE TABLE `contain_tab` (
`id_contain` int(11) NOT NULL,
`org_id` varchar(5) NOT NULL,
`container` varchar(24) DEFAULT NULL,
`eta_dest` date DEFAULT NULL,
`mfest_id` varchar(30) DEFAULT NULL,
`sl_number` varchar(30) DEFAULT NULL,
`orig_id` varchar(8) DEFAULT NULL,
`cu_date` date DEFAULT NULL,
`cv_date` date DEFAULT NULL,
`vehicle` varchar(32) DEFAULT NULL,
`user_defined_field1` varchar(35) DEFAULT NULL,
`user_defined_field2` varchar(35) DEFAULT NULL
`created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8;

我遇到错误MySQL 说:文档

1093 - 您无法在 FROM 子句中指定用于更新的目标表“contain”

请帮我修复错误

Answer 1

为表名添加反引号contain，因为它是关键字

`contain`