mysql - 日期 日期变量

Question

“考试”表中出现错误，原因是日期 Date 变量 - 我几乎到处(使用 Google)搜索了答案。

Drop table if exists exams;
CREATE TABLE administration2.exams (
date DATE,
censor VARCHAR(45) ,
idstudents VARCHAR(11),
idcourses VARCHAR(11),
grade INT (11),
PRIMARY KEY (date,censor));

insert into exams(date, censor, idstudents, idcourses, grade)
('2013-11-06', 'Ole Pedersen','201210066', 'dDB', 7),

这是问题所在 ('2013-11-06') - 它说:

`syntax_error, UNEXPECTED TEXT_STRING, expecting SELECT_SYM.

我该如何解决这个问题？

Answer 1

您缺少 values 语句:

insert into exams(date, censor, idstudents, idcourses, grade)
    values ('2013-11-06', 'Ole Pedersen','201210066', 'dDB', 7);

如果去掉括号，您也可以使用 select 执行此操作:

insert into exams(date, censor, idstudents, idcourses, grade)
    select '2013-11-06', 'Ole Pedersen','201210066', 'dDB', 7;