问题描述
我尝试使用以下 SQL 来创建表和一些列.作为其中的一部分，我希望其中两列自动递增一个整数.当我尝试使用下面的代码时，它给了我一个错误.
I have the below SQL I am trying to use to create a table and some columns. As part of it, I want two of the columns to autoincrement an integer. When I try using the below code it gives me an error.
CREATE TABLE IF NOT EXISTS 'tasks' (
'rowID' INTEGER,
'gID' INTEGER,
'task' TEXT,
'status' TEXT,
'position' INTEGER,
'updated' INTEGER,
'inlist' TEXT,
'deleted' TEXT,
PRIMARY KEY AUTOINCREMENT ('rowID','position')
)
当我从 SQL 中删除关键字AUTOINCREMENT"时，它可以正常工作.
When I remove the keyword "AUTOINCREMENT" from the SQL it works fine.
是否可以有两个自增列?如果没有，有没有一种方法可以让一列在插入时自动从另一列(自动递增)中获取值?
Is it possible to have two autoincrementing columns? If not, is there a way I can have one column automatically take the value from the other (auto-incrementing) column as its being inserted?
谢谢
推荐答案
你不能有两个自增字段.您应该使用单个自动增量字段.鉴于这两个字段对于每一行总是具有相同的值，因此没有理由必须使用这些字段.
You can't have two autoincrement fields. You should use a single autoincrement field. Given that both fields would always have the same value for every row, there's no reason to have to such fields anyway.
这篇关于SQLite多个自动增量列?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！