mysql - phpMyAdmin - 执行查询时出现 1064 错误

Question

我尝试在 phpMyAdmin 中执行查询，但它给我一个错误:

1064 - 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 ') REFERENCES Online Shopping.Customer () ON DELETE NO ACTION ' at line 11

查询是:

CREATE  TABLE IF NOT EXISTS `Online Shopping`.`Order_Details` (
  `Order_Id` INT NOT NULL ,
  `Product_Name` VARCHAR(45) NULL ,
  `Price_For_Each_Product` VARCHAR(45) NULL ,
  `No_of_Product_ordered` VARCHAR(45) NULL ,
  `Ordered_Date` DATE NULL ,
  `Total_Price` VARCHAR(45) NULL ,
  `Generated_Key` VARCHAR(45) NULL ,
  PRIMARY KEY (`Order_Id`) ,
  CONSTRAINT `Customer_Id`
    FOREIGN KEY ()
    REFERENCES `Online Shopping`.`Customer` ()
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `Order_LineId`
    FOREIGN KEY ()
    REFERENCES `Online Shopping`.`Order_Line` ()
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

Answer 1

CREATE  TABLE IF NOT EXISTS `Online Shopping`.`Order_Details` (
  `Order_Id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT ,
  `Product_Name` VARCHAR(45) NULL ,
  `Price_For_Each_Product` VARCHAR(45) NULL ,
  `No_of_Product_ordered` VARCHAR(45) NULL ,
  `Ordered_Date` DATE NULL ,
  `Total_Price` VARCHAR(45) NULL ,
  `Generated_Key` VARCHAR(45) NULL,
  CONSTRAINT `Customer_Id`
    FOREIGN KEY (Customer_ID)
    REFERENCES `Online Shopping`(Customer)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `Order_LineId`
    FOREIGN KEY (Customer_ID)
    REFERENCES `Online Shopping`(Order_Line)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;