“自动增量"附近的错误 [英] Error in near 'Autoincrement'

问题描述

我在 AUTOINCREMENT 附近遇到语法错误.这个错误的原因是什么?

创建表人(id INTEGER NOT NULL AUTOINCREMENT,名称文本非空);创建表部门(id INTEGER NOT NULL AUTOINCREMENT,名称文本不为空，FOREIGN KEY (leader) REFERENCES person(id));

解决方案

根据 SQLite FAQ

a> 你必须声明一个 INTEGER PRIMARY KEY 或 INTEGER PRIMARY KEY AUTOINCREMENT 列来实现这一点.

I get a syntax error near AUTOINCREMENT. What is the cause of this error?

CREATE TABLE person (
    id INTEGER NOT NULL AUTOINCREMENT,
    name TEXT NOT NULL
);

CREATE TABLE department (
    id INTEGER NOT NULL AUTOINCREMENT,
    name TEXT NOT NULL,
    FOREIGN KEY (leader) REFERENCES person(id)
);

解决方案

According to SQLite FAQ you have to declare either a INTEGER PRIMARY KEY or INTEGER PRIMARY KEY AUTOINCREMENT column to achieve that.

这篇关于“自动增量"附近的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！