“字段列表”中包含现有数据的未知列

Question

| enrollment | CREATE TABLE `enrollment` (
  `SSN` varchar(9) NOT NULL,
  `CourseNumber` varchar(4) NOT NULL,
  `Quarter` varchar(10) NOT NULL,
  `Grade` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SSN`,`CourseNumber`,`Quarter`),
  KEY `CourseNumber` (`CourseNumber`),
  KEY `Quarter` (`Quarter`),
  CONSTRAINT `enrollment_ibfk_1` FOREIGN KEY (`SSN`) REFERENCES `Student` (`SSN`),
  CONSTRAINT `enrollment_ibfk_2` FOREIGN KEY (`CourseNumber`) REFERENCES `Course` (`CourseNumber`),
  CONSTRAINT `enrollment_ibfk_3` FOREIGN KEY (`Quarter`) REFERENCES `section` (`Quarter`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |


| student | CREATE TABLE `student` (
  `SSN` varchar(9) NOT NULL,
  `Name` varchar(15) DEFAULT NULL,
  `Major` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`SSN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

mysql> select * from student;
+-----------+----------------+-----------+
| SSN       | Name           | Major     |
+-----------+----------------+-----------+
| 111111111 | Danny James    | History   |
| 123123123 | John White     | Chemistry |


mysql> INSERT INTO ENROLLMENT (SSN, CourseNumber, Quarter, Grade) 
values (‘111111111’, '220','Winter2014', 'A');

错误1054 (42S22)：“字段列表”中未知列‘111111111’

我是SQL的初学者。显然，我有一个学生，他们的“111111111”作为他们的SSN。但它仍然说它是未知的列。请帮帮忙。

Answer 1

你的问题是：

mysql>插入到注册(SSN，CourseNumber，季度，年级)值(‘111111111’，'220'，‘Winter2014a’)；^

您已经使用了curly引号‘ ’而不是标准单引号'来定义第一个值。

修复：

  mysql> INSERT INTO ENROLLMENT (SSN, CourseNumber, Quarter, Grade) 
  values ('111111111', '220','Winter2014', 'A');