CREATE TABLE t_questionCopy (（5） t_question)

这个 SQL 语句有一些问题，应该是这样的：

CREATE TABLE t_questionCopy
SELECT * FROM t_question WHERE 1=0;

这将复制 `t_question` 表的结构和索引，但不会复制数据。如果你想将 `t_question` 表的数据也复制到 `t_questionCopy` 表中，可以使用以下 SQL 语句：

INSERT INTO t_questionCopy SELECT * FROM t_question;

这将从 `t_question` 表中选择所有行，并将它们插入到 `t_questionCopy` 表中。注意，`t_questionCopy` 表必须已经存在，并且必须与 `t_question` 表具有相同的列名和数据类型。

相关问题

以下建表语句正确的有（ ） 2分 CREATE TABLE table_b AS SELECT * FROM table_a; CREATE TABLE table_b STORED as ORC_TRANSACTION AS SELECT * FROM table_a; CREATE TABLE table_b STORED as TEXTFILE AS SELECT * FROM table_a; CREATE TABLE table_b STORED as HOLODESK AS SELECT * FROM table_a;

以下表语句中正确的是：

- CREATE TABLE table_b SELECT * FROM table_a;
该语句用创建一个名为table_b的表，将表table_a中的所有数据复制到新表中。

- CREATE table_b STORED as ORC_TRANSACTION AS * FROM table_a;
该语是错误的。ORC_TRANSACTION不是有效的存储格式。

- CREATE TABLE table_b STORED as TEXTFILE AS SELECT * FROM table_a;
该语句是正确的。它创建了一个名为table_b的表，并且将表table_a中的数据以TEXTFILE格式存储到新表中。

- CREATE TABLE table_b STORED as HOLODESK AS SELECT * FROM table_a;
该语句是错误的。HOLODESK不是一个有效的存储格式。

所以，正确的建表语句有两个：
1. CREATE TABLE table_b AS SELECT * FROM table_a;
2. CREATE TABLE table_b STORED as TEXTFILE AS SELECT * FROM table_a;

create table ACT_GE_PROPERTY

Sure! Here's the SQL query to create the "ACT_GE_PROPERTY" table:

CREATE TABLE ACT_GE_PROPERTY (
    NAME VARCHAR(255) NOT NULL,
    VALUE VARCHAR(4000),
    REV_ INTEGER,
    PRIMARY KEY (NAME)
);

This query creates the "ACT_GE_PROPERTY" table with three columns: "NAME", "VALUE", and "REV_". The "NAME" column stores the property name (limited to 255 characters), the "VALUE" column stores the property value (limited to 4000 characters), and the "REV_" column is an integer used for revision tracking. The primary key is set on the "NAME" column.