mysql - MySQL 工作台不会将数据库发送到 localhost/phpmyadmin

Question

我正在尝试将我的数据库从 Mysql Workbench 版本（10.4.11）发送到我的 localhost/phpmyadmin ，（在使用 mysql 和 xampp 的 Windows 10 上）我打开了 mysql 和 apache，但是当我尝试转发工程时出现此错误D B ，

任何建议，问题或另一种更简单的方法将不胜感激基本上我想要的是这些表已连接并且能够运行一个简单的查询，例如创建一个驱动程序并需要他的 ID、姓名等。

Executing SQL script in server
ERROR: Error 1064: 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 '
  CONSTRAINT `fk_tblDriver_tblPolicy1`
 FOREIGN KEY (`tblPolicy_idPolicy`)
 ' at line 17
SQL Code:
    -- -----------------------------------------------------
    -- Table `InsuraceCO`.`tblDriver`
    -- -----------------------------------------------------
    CREATE TABLE IF NOT EXISTS `InsuraceCO`.`tblDriver` (
      `idDriver` INT NOT NULL,
      `FirstName` VARCHAR(40) NOT NULL,
      `LastName` VARCHAR(45) NOT NULL,
      `Age` INT NULL,
      `Street address` VARCHAR(40) NULL,
      `AddressPostcode` VARCHAR(45) NULL,
      `Phone Number` INT NULL,
      `LicenseStatus` VARCHAR(20) NOT NULL,
      `DateLicenced` VARCHAR(45) NOT NULL,
      `LicenceNumber` INT NOT NULL,
      `tblPolicy_idPolicy` INT NOT NULL,
      PRIMARY KEY (`idDriver`, `tblPolicy_idPolicy`),
      INDEX `fk_tblDriver_tblPolicy1_idx` (`tblPolicy_idPolicy` ASC) VISIBLE,
      CONSTRAINT `fk_tblDriver_tblPolicy1`
        FOREIGN KEY (`tblPolicy_idPolicy`)
        REFERENCES `InsuraceCO`.`tblPolicy` (`idPolicy`)
        ON DELETE NO ACTION
        ON UPDATE NO ACTION)
    ENGINE = InnoDB

SQL script execution finished: statements: 6 succeeded, 1 failed

Fetching back view definitions in final form.
Nothing to fetch    

这是我的代码

    -- MySQL Workbench Forward Engineering

    SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
    SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
     SET @OLD_SQL_MODE=@@SQL_MODE,




 SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

    -- -----------------------------------------------------
    -- Schema InsuraceCO
    -- -----------------------------------------------------

    -- -----------------------------------------------------
    -- Schema InsuraceCO
    -- -----------------------------------------------------
    CREATE SCHEMA IF NOT EXISTS `InsuraceCO` DEFAULT CHARACTER SET utf8 ;
    USE `InsuraceCO` ;

    -- -----------------------------------------------------
    -- Table `InsuraceCO`.`tblPolicy`
    -- -----------------------------------------------------
    CREATE TABLE IF NOT EXISTS `InsuraceCO`.`tblPolicy` (
     `idPolicy` INT NOT NULL,
     `PolicyEffectiveDate` VARCHAR(45) NULL,
     `PolicyExpirationDate` VARCHAR(45) NULL,
     `TotalCost` INT NULL,
  `PlayerID` INT NULL,
  `LastUpdate` VARCHAR(45) NULL,
  `tblPolicycol` VARCHAR(45) NULL,
  PRIMARY KEY (`idPolicy`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `InsuraceCO`.`tblDriver`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `InsuraceCO`.`tblDriver` (
  `idDriver` INT NOT NULL,
  `FirstName` VARCHAR(40) NOT NULL,
  `LastName` VARCHAR(45) NOT NULL,
  `Age` INT NULL,
  `Street address` VARCHAR(40) NULL,
  `AddressPostcode` VARCHAR(45) NULL,
  `Phone Number` INT NULL,
  `LicenseStatus` VARCHAR(20) NOT NULL,
  `DateLicenced` VARCHAR(45) NOT NULL,
  `LicenceNumber` INT NOT NULL,
  `tblPolicy_idPolicy` INT NOT NULL,
  PRIMARY KEY (`idDriver`, `tblPolicy_idPolicy`),
  INDEX `fk_tblDriver_tblPolicy1_idx` (`tblPolicy_idPolicy` ASC) VISIBLE,
  CONSTRAINT `fk_tblDriver_tblPolicy1`
    FOREIGN KEY (`tblPolicy_idPolicy`)
    REFERENCES `InsuraceCO`.`tblPolicy` (`idPolicy`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `InsuraceCO`.`tblVehicle`
-- -----------------------------------------------------
    CREATE TABLE IF NOT EXISTS `InsuraceCO`.`tblVehicle` (
  `idVehicle` INT NOT NULL,
  `VehiclePlateNumber` VARCHAR(45) NULL,
  `VehicleBrand` VARCHAR(45) NULL,
  `VehicleModel` VARCHAR(45) NULL,
  `RegistrationYear` VARCHAR(45) NULL,
  `RegistrationNumber` VARCHAR(45) NULL,
  `EngineNumber` VARCHAR(45) NULL,
  `EngineSize` VARCHAR(45) NULL,
  `idPolicy` INT NOT NULL,
  `tblPolicy_idPolicy` INT NOT NULL,
  PRIMARY KEY (`idVehicle`, `tblPolicy_idPolicy`),
  INDEX `fk_tblVehicle_tblPolicy1_idx` (`tblPolicy_idPolicy` ASC) VISIBLE,
  CONSTRAINT `fk_tblVehicle_tblPolicy1`
    FOREIGN KEY (`tblPolicy_idPolicy`)
    REFERENCES `InsuraceCO`.`tblPolicy` (`idPolicy`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `InsuraceCO`.`tblViolationCodes`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `InsuraceCO`.`tblViolationCodes` (
  `idViolationCodes` INT NOT NULL,
  `ViolationDescription` VARCHAR(1000) NULL,
  PRIMARY KEY (`idViolationCodes`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `InsuraceCO`.`tblDriver_tblVehicle`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `InsuraceCO`.`tblDriver_tblVehicle` (
  `tblDriver_intDriverID` INT NOT NULL,
  `tblVehicle_intVehicle` INT NOT NULL,
  PRIMARY KEY (`tblDriver_intDriverID`, `tblVehicle_intVehicle`),
  INDEX `fk_tblDriver_has_tblVehicle_tblVehicle1_idx` (`tblVehicle_intVehicle` ASC) VISIBLE,
  INDEX `fk_tblDriver_has_tblVehicle_tblDriver_idx` (`tblDriver_intDriverID` ASC) VISIBLE,
  CONSTRAINT `fk_tblDriver_has_tblVehicle_tblDriver`
    FOREIGN KEY (`tblDriver_intDriverID`)
    REFERENCES `InsuraceCO`.`tblDriver` (`idDriver`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tblDriver_has_tblVehicle_tblVehicle1`
    FOREIGN KEY (`tblVehicle_intVehicle`)
    REFERENCES `InsuraceCO`.`tblVehicle` (`idVehicle`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `InsuraceCO`.`tblDriver_tblViolationCodes`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `InsuraceCO`.`tblDriver_tblViolationCodes` (
  `tblDriver_intDriverID` INT NOT NULL,
  `tblViolationCodes_idtblViolationCodes` INT NOT NULL,
  PRIMARY KEY (`tblDriver_intDriverID`, `tblViolationCodes_idtblViolationCodes`),
  INDEX `fk_tblDriver_has_tblViolationCodes_tblViolationCodes1_idx` (`tblViolationCodes_idtblViolationCodes` ASC) VISIBLE,
  INDEX `fk_tblDriver_has_tblViolationCodes_tblDriver1_idx` (`tblDriver_intDriverID` ASC) VISIBLE,
  CONSTRAINT `fk_tblDriver_has_tblViolationCodes_tblDriver1`
    FOREIGN KEY (`tblDriver_intDriverID`)
    REFERENCES `InsuraceCO`.`tblDriver` (`idDriver`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tblDriver_has_tblViolationCodes_tblViolationCodes1`
    FOREIGN KEY (`tblViolationCodes_idtblViolationCodes`)
    REFERENCES `InsuraceCO`.`tblViolationCodes` (`idViolationCodes`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
   SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
   SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;```

标签： mysqldatabasephpmyadminmariadbmysql-workbench