当前位置:   article > 正文

mysql设置外键报1064,使用MySQL Workbench添加外键时出现MySQL错误1064

mysql添加外键命令 on delete cascade 1064

So I have an error, when I want to add a foreign key. I added the foreign key in MySQL Workbench with an EER Diagram Model. The lines workbench tries to add are:`

CREATE SCHEMA IF NOT EXISTS `barberDB` DEFAULT CHARACTER SET latin1 ;

USE `barberDB` ;

-- -----------------------------------------------------

-- Table `barberDB`.`BARBER`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `barberDB`.`BARBER` (

`ID` INT NOT NULL AUTO_INCREMENT,

`name` VARCHAR(45) NULL,

PRIMARY KEY (`ID`))

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `barberDB`.`CUSTOMER`

-- -----------------------------------------------------

CREATE TABLE I

声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/不正经/article/detail/509019
推荐阅读
相关标签
  

闽ICP备14008679号