将oracle脚本转换为mysql脚本

Question

在这方面需要帮助，我正在将数据库从oracle迁移到mysql。我正在oracle中运行下面的查询--它工作正常，但是在mysql中

INSERT INTO xyz(rid, pid)
SELECT rid, pid
  FROM ((SELECT distinct rd, 
              (SELECT p.pid FROM abc p WHERE p.permission='jury') AS pid
          FROM xyz
         WHERE pid IN (SELECT p.pid
                         FROM abc p
                        WHERE p.permission in ('jury'))
       ));

获取以下错误

Every derived table must have its own alias [SQL State=42000, DB Errorcode=1248]

Answer 1

我不是MySQL用户，但是搜索错误显示它期望内联视图有一个别名：

insert into xyz (rid, pid)
  select rid, pid
  from   ( (select distinct rd,
                            (select p.pid
                             from   abc p
                             where  p.permission = 'jury')
                              as pid
            from   xyz
            where  pid in (select p.pid
                           from   abc p
                           where  p.permission in ('jury')))) res;

然而，这不是一种非常非常复杂的方法吗？

insert into xyz (rid, pid)                         
select distinct xyz.rd,
                abc.pid
from   xyz
       inner join abc on (xyz.pid = abc.pid and abc.permission = 'jury');