问题1:
CREATE TABLE table_name_temp AS
SELECT * FROM table_name
WHERE rowid IN
(SELECT head_rowid FROM chained_rows
WHERE table_name = 'table_name');上述语句是创建一个表,但是中间的select语句的功能是:在系统的chained_rows中并且表明为table_name的发生行链的元组,并将其插入到table_name_temp中,是吗???
请教各位!!!问题2:下面这条语句语法对吗???
INSERT INTO table_name SELECT * FROM table_name_temp;
请教高手!!!
CREATE TABLE table_name_temp AS
SELECT * FROM table_name
WHERE rowid IN
(SELECT head_rowid FROM chained_rows
WHERE table_name = 'table_name');上述语句是创建一个表,但是中间的select语句的功能是:在系统的chained_rows中并且表明为table_name的发生行链的元组,并将其插入到table_name_temp中,是吗???
请教各位!!!问题2:下面这条语句语法对吗???
INSERT INTO table_name SELECT * FROM table_name_temp;
请教高手!!!
当我执行完后,出现了 ‘0 rows created’
这是怎么回事???
SELECT * FROM table_name
WHERE rowid IN
(SELECT head_rowid FROM chained_rows
WHERE table_name = 'table_name');
----------------------------------------------
WHERE条件后的table_name = 'TABLE_NAME',单引号里的表名全部大写。试试