mysql - 我无法在表中创建外键。不断出现错误消息

Question

代码和错误的图像

CREATE TABLE Ticket(
    -> Ticket_No INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
    -> BusID INT,
    -> Registration_No INT,
    -> Seat_No INT NOT NULL,
    -> FOREIGN KEY BusID REFERENCES Bus(BusID),
    -> FOREIGN KEY Registration_No REFERENCES Passenger(Registration_No));

错误信息：

ERROR 1064 (42000): You have an error in your SQL syntax;
check the manual that corresponds to your MariaDB server version for the right syntax to use near 'REFERENCES Bus(BusID),
FOREIGN KEY Registration_No REFERENCES Passenger(Registra' at line 6

我正在尝试向此表添加外键，但此错误消息不断出现。引用的表和列名是正确的。我也尝试过更改列名。请帮忙。

标签： mysql

Answer 1

您需要在引用列周围加上括号。

...
FOREIGN KEY (BusID) REFERENCES Bus(BusID),
...

另一个是模拟的。