SELECT INTO with HSQLDB

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

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

sql database select hsqldb

Ok I found very easier way to do this.

select * into t_bckp FROM t;

Its interesting.

CodeHunter