MySQL 查询运行失败 - MySQL 错误 : #1064

Question

我收到错误:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' dag = zaterdag, start = 15, start_minuten = 00, eind = 19, eind_minuten = 00, d' at line 1

当我尝试在 Phpmyadmin 中运行此查询时:

SELECT * FROM rooster WHERE medewerker = 00126311, dag = zaterdag, start = 15, start_minuten = 00, eind = 19, eind_minuten = 00, datum = 2016-09-17, weeknummer = 37, leiding = 0

我的表(公鸡)结构:

id int(4)
medewerker varchar(10)
dag varchar(10)
start varchar(25)
start_minuten varchar(25)
eind varchar(25)
eind_minuten varchar(25)
datum date
weeknummer int(2)
leiding int(1)

medewerker 与另一个表内联，它显示员工的编号。

翻译:zaterdag 是星期六的意思medewerker 意思是员工dag 表示一天分钟意味着分钟datum 表示日期weeknummer 平均周数leiding 表示老板(如果老板是1，他就是那天的老板)

如果有人能帮助我解决这个问题，我将不胜感激。

Answer 1

你能试试这个吗:如果数据类型是 VARCHAR 或 CHAR，你还必须用单引号将值括起来

SELECT * 
FROM rooster 
WHERE medewerker = '00126311' 
    AND dag = 'zaterdag'
    AND start = '15'
    AND start_minuten = '00'
    AND eind = '19'
    AND eind_minuten = '00' 
    AND datum = '2016-09-17'
    AND weeknummer = 37 
    AND leiding = 0