到達建表那一塊,用mysql bench 建的兩張表,在navicate報錯打不開,請問老師或同學們如何處理?
USE `mydb` ;
-- -----------------------------------------------------
-- Table `mydb`.`user`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`user` ;
CREATE TABLE IF NOT EXISTS `mydb`.`user` (
? `user_id` INT NOT NULL AUTO_INCREMENT,
? `username` VARCHAR(20) NOT NULL,
? `password` CHAR(32) NOT NULL,
? `create_at` DATETIME NOT NULL,
? PRIMARY KEY (`user_id`),
? INDEX `username` (`username` ASC) VISIBLE,
? INDEX `create_at` (`create_at` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
-- -----------------------------------------------------
-- Table `mydb`.`article`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`article` ;
CREATE TABLE IF NOT EXISTS `mydb`.`article` (
? `article_id` INT NOT NULL,
? `title` VARCHAR(40) NOT NULL,
? `content` TEXT NOT NULL,
? `user_id` INT NOT NULL,
? PRIMARY KEY (`article_id`),
? INDEX `fk_article_user_idx` (`user_id` ASC) VISIBLE,
? CONSTRAINT `fk_article_user`
? ? FOREIGN KEY (`user_id`)
? ? REFERENCES `mydb`.`user` (`user_id`)
? ? ON DELETE NO ACTION
? ? ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
[SQL] Finished successfully with error
