当我运行代码时，我在JavaDerby数据库中得到了这个外键错误

fdbelqdn 于 2021-06-30 发布在 Java

关注(0)|答案(3)|浏览(423)

当我运行代码时，我在javaderby数据库中得到了这个外键错误

CREATE TABLE PURCHASE (
    $PURCHASEID INT NOT NULL GENERATED ALWAYS AS IDENTITY,$
    $PURCHASEDATE DATE,$
    $PURCHASEQUANTITY INT,$
    $CHICPRICE DOUBLE,$
    $CUSTNIC VARCHAR(14) NOT NULL,$
    $PRIMARY KEY (PURCHASEID)$
       $ FOREIGN KEY (CUSTNIC) REFERENCES CUSTOMER(CUSTNIC)$
);

[异常，错误代码30000，sqlstate 42x01]语法错误：在第8行第9列遇到“foreign”。第8行第9列

Java sql derby

来源：https://stackoverflow.com/questions/65265996/i-am-getting-this-foreign-key-error-in-java-derby-database-when-i-run-the-code

3条答案

按热度按时间

ckx4rj1h1#

试试这个

CREATE TABLE PURCHASE (
    $PURCHASEID INT NOT NULL GENERATED ALWAYS AS IDENTITY,$
    $PURCHASEDATE DATE,$
    $PURCHASEQUANTITY INT,$
    $CHICPRICE DOUBLE,$
    $CUSTNIC VARCHAR(14) NOT NULL,$
    $PRIMARY KEY (PURCHASEID)$
       $FOREIGN KEY (CUSTNIC) REFERENCES CUSTOMER(CUSTNIC)$
);

赞(0）回复(0）举报 2021-06-30

8aqjt8rx2#

尝试创建表，然后使用添加外键约束

alter table PURCHASE add FOREIGN KEY (CUSTNIC) 
REFERENCES CUSTOMER (CUSTNIC)

似乎有一个“，”失踪前外国

赞(0）回复(0）举报 2021-06-30

0yycz8jy3#

如果在主键后加逗号，应该可以

CREATE TABLE PURCHASE (
    $PURCHASEID INT NOT NULL GENERATED ALWAYS AS IDENTITY,$
    $PURCHASEDATE DATE,$
    $PURCHASEQUANTITY INT,$
    $CHICPRICE DOUBLE,$
    $CUSTNIC VARCHAR(14) NOT NULL,$
    $PRIMARY KEY (PURCHASEID),$
       $ FOREIGN KEY (CUSTNIC) REFERENCES CUSTOMER(CUSTNIC)$
);

赞(0）回复(0）举报 2021-06-30

我来回答

当我运行代码时，我在JavaDerby数据库中得到了这个外键错误

3条答案

相关问题

热门标签

最新问答