SQLite的等效语句是否有一个set_insert?

时间:2021-04-05 09:36:44

In TSQL there is

在TSQL中有

SET IDENTITY_INSERT ON;

is there a functional equivalent in SQLite?

SQLite中有功能等价物吗?

1 个解决方案

#1


12  

SQLite always allows inserting a value into the primary key column; automatically generated values are used only when the inserted value is NULL (explicitly or omitted).

SQLite始终允许将值插入主键列;仅当插入的值为NULL(显式或省略)时才使用自动生成的值。

For details, see the documentation.

有关详细信息,请参阅文档。

#1


12  

SQLite always allows inserting a value into the primary key column; automatically generated values are used only when the inserted value is NULL (explicitly or omitted).

SQLite始终允许将值插入主键列;仅当插入的值为NULL(显式或省略)时才使用自动生成的值。

For details, see the documentation.

有关详细信息,请参阅文档。