mysql workbench数据导入,外键错误

gj3fmq9x  于 2021-06-17  发布在  Mysql
关注(0)|答案(1)|浏览(314)

我在mysql workbench 8.0ce中工作,我创建了两个表,一个用于person,另一个用于persons direction,我试图导出数据,但它抛出错误

  1. ERROR 1064 (42000) at line 67: 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 '
  2. CONSTRAINT `fk_PersonaDireccion`
  3. FOREIGN KEY (`idPersona`)
  4. REFERENCES' at line 8
  5. Operation failed with exitcode 1

这是sql代码

  1. CREATE TABLE IF NOT EXISTS `dinSchema`.`Personas` (
  2. `nombre` VARCHAR(20) NOT NULL,
  3. `apellidoP` VARCHAR(20) NOT NULL,
  4. `apellidoM` VARCHAR(20) NOT NULL,
  5. `foto` MEDIUMBLOB NULL,
  6. `fechaCaptura` TIMESTAMP(6) NOT NULL,
  7. `escolaridad` VARCHAR(25) NOT NULL,
  8. `carrera` VARCHAR(25) NULL,
  9. `telefono` VARCHAR(10) NULL,
  10. `correo` VARCHAR(50) NOT NULL,
  11. `sexo` VARCHAR(10) NOT NULL,
  12. `rfc` VARCHAR(13) NOT NULL,
  13. `curp` VARCHAR(18) NOT NULL,
  14. `observaciones` MEDIUMTEXT NULL,
  15. `idPersonas` INT NOT NULL,
  16. PRIMARY KEY (`idPersonas`))
  17. ENGINE = InnoDB;
  18. -- -----------------------------------------------------
  19. -- Table `dinSchema`.`direccion`
  20. -- -----------------------------------------------------
  21. DROP TABLE IF EXISTS `dinSchema`.`direccion` ;
  22. CREATE TABLE IF NOT EXISTS `dinSchema`.`direccion` (
  23. `pais` VARCHAR(6) NOT NULL DEFAULT 'México',
  24. `estado` VARCHAR(20) NOT NULL,
  25. `ciudad` VARCHAR(25) NOT NULL,
  26. `direccion` VARCHAR(150) NOT NULL,
  27. `cp` INT(8) NOT NULL,
  28. `idPersona` INT NOT NULL,
  29. INDEX `fk_PersonaDireccion_idx` (`idPersona` ASC) VISIBLE,
  30. CONSTRAINT `fk_PersonaDireccion`
  31. FOREIGN KEY (`idPersona`)
  32. REFERENCES `dinSchema`.`Personas` (`idPersonas`)
  33. ON DELETE RESTRICT
  34. ON UPDATE CASCADE)
  35. ENGINE = InnoDB;

接下来我附加eer图img

注意:“personas”id字段是最后一个,因为我删除了一个外键连接。

i1icjdpr

i1icjdpr1#

不知何故,我修复了它,取消选中“模型选项”中的“用户默认全局设置”,然后

  1. INDEX `fk_PersonaDireccion_idx` (`idPersona` ASC) VISIBLE

现在“direccion”表变成这样了

  1. CREATE TABLE IF NOT EXISTS `dinSchema`.`direccion` (
  2. `pais` VARCHAR(6) NOT NULL DEFAULT 'México',
  3. `estado` VARCHAR(20) NOT NULL,
  4. `ciudad` VARCHAR(25) NOT NULL,
  5. `direccion` VARCHAR(150) NOT NULL,
  6. `cp` INT(8) NOT NULL,
  7. `idPersona` INT NOT NULL,
  8. CONSTRAINT `fk_PersonaDireccion`
  9. FOREIGN KEY (`idPersona`)
  10. REFERENCES `dinSchema`.`Personas` (`idPersonas`)
  11. ON DELETE RESTRICT
  12. ON UPDATE CASCADE)
  13. ENGINE = InnoDB;
展开查看全部

相关问题