从sysibm.sysdummy1中创建表table1作为select .. [英] create table table1 as select .. from sysibm.sysdummy1

问题描述

在DERBY中，

我有一个名为TEST1的表.我可以完美地运行此代码.

I have a table which name is TEST1. I can run this code perfectly.

CREATE TABLE Table1 AS (SELECT * FROM TEST1) with no data

但是我无法运行此代码和德比.

But I can't run this code and derby.

CREATE TABLE Table1 AS (SELECT ..... FROM sysibm.sysdummy1) with no data

编辑器抛出此错误:

错误:CREATE TABLE语句不包含列列表.

ERROR: The CREATE TABLE statement does not include a column list.

ps:"SELECT ..... FROM sysibm.sysdummy1"可以正常工作.

ps: "SELECT ..... FROM sysibm.sysdummy1" works with no problem.

如何使用从sysibm.sysdummy1中选择'列'"创建表?

How can I create a table with using "select 'columns' from sysibm.sysdummy1" ?

推荐答案

在我的第一个代码中

CREATE TABLE Table1 AS (SELECT ..... x, y, z , 0 FROM sysibm.sysdummy1) with no data

我在查询中删除了逗号和0并进行了修复！这样

I deleted comma and 0 in query and fixed it! Like that

CREATE TABLE Table1 AS (SELECT ..... x, y, z FROM sysibm.sysdummy1) with no data

这篇关于从sysibm.sysdummy1中创建表table1作为select ..的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！