SQLITE查询结果到临时表中 [英] SQLITE Query results into a temp table

问题描述

我以前没有使用过 SQLite 并且无法弄清楚语法，我已经在 SQL Server 如果有帮助。

I haven't used SQLite before and can't figure out the syntax, I have this working in SQL Server if it helps.

我需要将结果放入临时表中，以便重新使用它们。

I need to put the results into a temp table so I can reuse them.

// SQL Server

//SQL Server

WITH FT_CTE AS
(
SELECT pID, cID FROM brFTNode_Children 
WHERE pID = 1
UNION ALL
    SELECT e.pID, e.cID FROM brFTNode_Children e
    INNER JOIN FT_CTE ftCTE on (ftCTE.cID = e.pID)
)
SELECT * INTO #ParentChild FROM FT_CTE;

// SQLite try

//SQLite try

WITH FT_CTE AS
(
SELECT pID, cID FROM brFTNode_Children 
WHERE pID = 1
UNION ALL
    SELECT e.pID, e.cID FROM brFTNode_Children e
    INNER JOIN FT_CTE ftCTE on (ftCTE.cID = e.pID)
)
CREATE TEMPORARY TABLE ParentChild as SELECT * FROM FT_CTE;

我在附近收到 Error：语法错误

推荐答案

CREATE TABLE语句不允许CTE，但SELECT允许：

The CREATE TABLE statement does not allow CTEs, but the SELECT does:

CREATE TEMPORARY TABLE ParentChild AS
WITH FT_CTE AS (
    SELECT pID, cID FROM brFTNode_Children 
    WHERE pID = 1
    UNION ALL
    SELECT e.pID, e.cID FROM brFTNode_Children e
    INNER JOIN FT_CTE ftCTE ON (ftCTE.cID = e.pID)
)
SELECT * FROM FT_CTE;

这篇关于SQLITE查询结果到临时表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！