MySQL 插入 - varchar 列的反勾还是单引号？

Question

尝试创建 MySQL 数据库并插入一些新数据时，我收到错误 1054 - 字段列表中未知的列。我正在使用 MySQL Workbench 从 .mwb 文件转发工程师。我的创建表如下所示

CREATE TABLE IF NOT EXISTS `JarvisDB`.`jarvisFixtures` (
  `Id` INT NOT NULL,
  `Gender` VARCHAR(10) NOT NULL,
  `Section` VARCHAR(10) NOT NULL,
  `Team1` VARCHAR(10) NOT NULL,
  `Team2` VARCHAR(10) NOT NULL,
  `FixtureDate` VARCHAR(45) NOT NULL,
  `FixtureTime` VARCHAR(10) NOT NULL,
  `Venue` VARCHAR(20) NOT NULL,
  `Court` VARCHAR(5) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE INDEX `Id_UNIQUE` (`Id` ASC));

插入时看起来像这样

INSERT INTO `JarvisDB`.`jarvisFixtures` (`Id`, `Gender`, `Section`, `Team1`, `Team2`, `FixtureDate`, `FixtureTime`, `Venue`, `Court`) VALUES (1, 'Men', 'A', 'NW', 'Gauteng', '15 July 2015', '09:00', 'Potch CC', '3');

错误是提示“FixtureDate”列，这对我来说没有任何意义？通过阅读网络上的其他解决方案，如果列名被反引号或单引号包围，它似乎可能与此有关。但由于我的所有列都是 varchar 类型(不包括 PK)，我不明白为什么它只在到达这个特定列时才开始提示。

有人能解释一下这个问题吗？

更新

完整的代码现在看起来像这样 -

-- 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='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Schema JarvisDB
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema JarvisDB
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `JarvisDB` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `JarvisDB` ;

-- -----------------------------------------------------
-- Table `JarvisDB`.`jarvisFixtures`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `JarvisDB`.`jarvisFixtures` (
  Id INT NOT NULL,
  Gender VARCHAR(10) NOT NULL,
  Section VARCHAR(10) NOT NULL,
  Team1 VARCHAR(10) NOT NULL,
  Team2 VARCHAR(10) NOT NULL,
  FixtureD DATETIME NOT NULL,
  FixtureT VARCHAR(10) NOT NULL,
  Venue VARCHAR(20) NOT NULL,
  Court VARCHAR(5) NOT NULL,
  PRIMARY KEY (Id),
  UNIQUE INDEX `Id_UNIQUE` (Id ASC))
ENGINE = InnoDB;


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

-- -----------------------------------------------------
-- Data for table `JarvisDB`.`jarvisFixtures`
-- -----------------------------------------------------
START TRANSACTION;
USE `JarvisDB`;
INSERT INTO `JarvisDB`.`jarvisFixtures` (Id, Gender, Section, Team1, Team2, FixtureD, FixtureT, Venue, Court) VALUES (1, 'Men', 'A', 'NW', 'Gauteng', '15 July 2015', '09:00', 'Potch CC', '3');
INSERT INTO `JarvisDB`.`jarvisFixtures` (Id, Gender, Section, Team1, Team2, FixtureD, FixtureT, Venue, Court) VALUES (2, 'Men', 'A', 'NW', 'WP', '15 July 2015', '14:00', 'Potch CC', '2');
INSERT INTO `JarvisDB`.`jarvisFixtures` (Id, Gender, Section, Team1, Team2, FixtureD, FixtureT, Venue, Court) VALUES (3, 'Men', 'A', 'Northerns', 'Gauteng', '15 July 2015', '09:00', 'Potch CC', '1');
INSERT INTO `JarvisDB`.`jarvisFixtures` (Id, Gender, Section, Team1, Team2, FixtureD, FixtureT, Venue, Court) VALUES (4, 'Men', 'A', 'KZN', 'WP', '16 July 2015', '09:00', 'Defence', '5');
INSERT INTO `JarvisDB`.`jarvisFixtures` (Id, Gender, Section, Team1, Team2, FixtureD, FixtureT, Venue, Court) VALUES (5, 'Men', 'A', 'EP', 'NW', '16 July 2015', '12:00', 'Defence', '4');
INSERT INTO `JarvisDB`.`jarvisFixtures` (Id, Gender, Section, Team1, Team2, FixtureD, FixtureT, Venue, Court) VALUES (6, 'Men', 'A', 'WP', 'Northerns', '16 July 2015', '14:00', 'Puk', '5');

COMMIT;

仍然出现同样的错误

Answer 1

删除了插入命令中的引号，这将工作文件。在 MySQl 5.6 上运行良好

创建表 jarvisFixtures ( Id INT ， 性别 VARCHAR(10) , 部分 VARCHAR(10), Team1 VARCHAR(10) , 团队2 VARCHAR(10) , FixtureDate VARCHAR(45), FixtureTime VARCHAR(10), 地点 VARCHAR(20), 法院 VARCHAR(5), 主键(Id)， 唯一索引 Id_UNIQUE (Id ASC));

插入 jarvisFixtures(ID、性别、部分、Team1、Team2、FixtureDate、FixtureTime、 field 、球场)值(1、“男子”、“A”、“NW”、“豪登省”、“2015 年 7 月 15 日”) , '09:00', 'Potch CC', '3')