本文介绍了从sysibm.sysdummy1中创建表table1作为select ..的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在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
编辑器抛出此错误:
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 ..的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!