MYSQL 帮助不让我创建表

Question

我对为什么我的代码不起作用感到困惑。

CREATE TABLE DELIVERY (
VEHICLE_VEH_ID INT NOT NULL,
DRIVER_DR_ID INT NOT NULL,
DEL_DATE DATETIME NOT NULL,
DEL_TIME DATETIME NOT NULL,
PRIMARY KEY (VEHICLE_VEH_ID , DRIVER_DR_ID)
INDEX (DRIVER_DR_ID),
INDEX (VEHICLE_VEH_ID),
CONSTRAINT FK_VEHICLE_HAS_DRIVER_VEHICLE FOREIGN KEY (VEHICLE_VEH_ID) REFERENCES VEHICLE (VEH_ID) 
CONSTRAINT FK_VEHICLE_HAS_DRIVER_DRIVER FOREIGN KEY (DRIVER_DR_ID) DRIVER (DR_ID));

CREATE TABLE DRIVER (
 DR_ID INT NOT NULL PRIMARY KEY,
 DR_TITLE VARCHAR(15) NOT NULL,
 DR_FNAME VARCHAR(45) NOT NULL,
 DR_LNAME VARCHAR(45) NOT NULL,
 DR_DOB DATETIME NOT NULL,
 DR_LICENCENO VARCHAR(45) NOT NULL,
 DR_PHONE VARCHAR(15) NOT NULL,
 DR_EMAIL VARCHAR(45) NOT NULL);

CREATE TABLE VEHICLE (
 VEH_ID INT NOT NULL PRIMARY KEY,
 VEH_REG VARCHAR(15) NOT NULL,
 VEH_MAKE VARCHAR(45) NOT NULL,
 VEH_MODEL VARCHAR(45) NOT NULL,
 VEH_MILEAGE INT NOT NULL,
 VEH_MOTDATE DATETIME NOT NULL,
 VEH_SERVICEDATE DATETIME NOT NULL);





mysql> CREATE TABLE DELIVERY (
    -> VEHICLE_VEH_ID INT NOT NULL,
    -> DRIVER_DR_ID INT NOT NULL,
    -> DEL_DATE DATETIME NOT NULL,
    -> DEL_TIME DATETIME NOT NULL,
    -> PRIMARY KEY (VEHICLE_VEH_ID , DRIVER_DR_ID)
    -> INDEX (DRIVER_DR_ID),
    -> INDEX (VEHICLE_VEH_ID),
    -> CONSTRAINT FK_VEHICLE_HAS_DRIVER_VEHICLE , CONSTRAINT FK_VEHICLE_HAS_DRIVER_DRIVER  FOREIGN KEY (VEHICLE_VEH_ID) REFERENCES VEHICLE (VEH_ID) FOREIGN KEY (DRIVER_DR_ID) DRIVER (DR_ID));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INDEX (DRIVER_DR_ID),
INDEX (VEHICLE_VEH_ID),
CONSTRAINT FK_VEHICLE_HAS_DRIVER_V' at line 7
mysql>

我试图创建一个表，但它说我有一个错误，而我认为我不这样做。如果您能看到我做错了什么，我将不胜感激。感谢大家的帮助!

Answer 1

你忘记了一个逗号。

...
PRIMARY KEY (VEHICLE_VEH_ID , DRIVER_DR_ID), -- Need a comma here
INDEX (DRIVER_DR_ID),
...