无法明确的sqlite语法错误

发布于 2025-01-28 03:57:02 字数 485 浏览 2 评论 0原文

我正在尝试创建数据库的语句，并且在10个实体之后，我遇到了这个错误

错误：第83行：近“交易”：语法错误

第一行是第83行，其上下文是创建表的上下文

CREATE TABLE Transaction (
TransactionID INTEGER,
AccountID INTEGER REFERENCES User (AccountID),
ItemID INTEGER REFERENCES Item (ItemID),
Method STRING,
Price INTEGER,
TransactionDate DATE,
PRIMARY KEY (TransactionID)
);

，我似乎找不到问题，并且使用错误的空间无法使用ASCII的建议。通过再次手动编写同一件事来解决。

我什至还没有检查外国钥匙的完整性，而且它没有起作用。希望有人可以对我缺少的东西提供一些见解。

原文

I'm trying out statements for creating a database, and after 10 entities without any issues I ran into this error

Error: Near line 83: near "Transaction": syntax error

The first line is line 83 with it's context of creating a table

CREATE TABLE Transaction (
TransactionID INTEGER,
AccountID INTEGER REFERENCES User (AccountID),
ItemID INTEGER REFERENCES Item (ItemID),
Method STRING,
Price INTEGER,
TransactionDate DATE,
PRIMARY KEY (TransactionID)
);

Now I can't seem to find the issue, and suggestion's of something with ASCII using the wrong space couldn't be solved by writing the same thing again manually.

I haven't even gotten around to checking the integrity of my foreign keys, and it's not working. Hopefully somebody could provide some insight on what I'm missing.

分享到QQ

分享到微博