使用HSQLDB选择进入 [英] SELECT INTO with HSQLDB

问题描述

我正在尝试根据选择结果创建一个新表。

I am trying to create a new table from the result of a select. This works fine with SQL Server:

SELECT * INTO newTable FROM (SELECT col1, col2, col3 FROM oldTable) x;

现在，我想使用HSQLDB（2.2版）实现完全相同的功能。我试过几种形式，例如

Now, I want to achieve the exact same thing with HSQLDB (Version 2.2). I have tried several forms like

SELECT * INTO newTable FROM (SELECT col1, col2, col3 FROM oldTable);
SELECT INTO newTable FROM SELECT col1, col2, col3 FROM oldTable;
CREATE TABLE newTable AS SELECT col1, col2, col3 FROM oldTable;

所有这些变体都会导致某种形式的语法错误。如何使用HSQLDB从select创建表？

All these variants result in some form of syntax error. How can I create a table from a select with HSQLDB?

推荐答案

手册中有一个示例：

CREATE TABLE t (a, b, c) AS (SELECT * FROM atable) WITH DATA

$ b $创建表t（a，b，c）AS（SELECT * FROM atable） b

HSQLDB 需要在选择项周围加上括号（与所有其他DBMS不同），并且还需要 WITH DATA 子句

HSQLDB requires parentheses around the select (unlike all other DBMS) and it also requires the WITH DATA clause

这篇关于使用HSQLDB选择进入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！