SQLite的插入到表的SELECT * FROM [英] sqlite insert into table select * from
本文介绍了SQLite的插入到表的SELECT * FROM的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要从一个表将数据移动到另一个在我的Android应用程序
我想用下面的SQL语句:
插入MYTABLE2选择ID,状态risposta,DATETIME('现在')data_ins从MYTABLE 2
不幸的是在表MYTABLE2有一个_ID列AUTOINCREMENT。 我能做什么?
感谢。
编辑: 这是我的MYTABLE2的,桌子,我想填充与另一个表中的数据:
CREATE TABLE答案(_idINTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
ID_QUESTIONINTEGER,DATE_INSDATETIME默认
(CURRENT_DATE),答案INTEGER)
解决方案
明确地插入
子句中指定的列名,
INSERT INTO destinationTable(risposta,data_ins)
选择状态risposta,DATETIME('现在')data_ins
从sourceTable
I need to move data from one table to another in my Android app
I would like to use the following sql:
insert into MYTABLE2 select id, STATUS risposta, DATETIME('now') data_ins from MYTABLE 2
Unfortunately in table MYTABLE2 there is an _ID column AUTOINCREMENT. What could I do?
Thanks.
EDIT: this is my MYTABLE2 the, the table I would like to populate with data from another table:
CREATE TABLE "ANSWERS" ("_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ,
"ID_QUESTION" INTEGER,"DATE_INS" DATETIME DEFAULT
(CURRENT_DATE) , "ANSWER" INTEGER)
解决方案
explicitly specify the column name in the INSERT
clause,
INSERT INTO destinationTable (risposta, data_ins)
SELECT STATUS risposta, DATETIME('now') data_ins
FROM sourceTable
这篇关于SQLite的插入到表的SELECT * FROM的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文