mysql - sqlite复制同一个表中的数据

Question

我有通过查询创建的表

CREATE TABLE [ConsignmentBody] ([ConsignmentBodyID] INTEGER PRIMARY KEY AUTOINCREMENT,
                                [OID] VARCHAR(64),
                                [Body] CLOB);

CREATE UNIQUE INDEX [ConsignmentBody_OID] ON [ConsignmentBody] ([OID] ASC);

我需要处理具有唯一id的同一个表中的数据。

我尝试过:

insert into ConsignmentBody(ConsignmentBodyID, body.[OID],body.[Body])
select (MAX(body.[ConsignmentBodyID])+1), body.[OID], body.[Body] 
from [ConsignmentBody] body

throws near "." syntax error

插入ConsignmentBody(null，body.[OID]，body.[Body])选择正文.[ConsignmentBodyID]、正文.[OID]、正文.[正文]来自 [ConsignmentBody] 正文

throws near "null" syntax error

如何解决？

Answer 1

您已在 ConsignmentBodyID 上设置了自动增量。为什么必须手动设置该值？只需插入没有主键的记录，它就会自动设置

insert into ConsignmentBody(OID, Body)
select OID, Body 
from ConsignmentBody