MySQL:SQL 语法错误 |限制 0, 25 [英] MySQL : error in your SQL syntax | LIMIT 0, 25

问题描述

我不明白这个错误，请大家帮帮我.为什么我收到这个错误..我的查询有问题吗?

I dont understand this error, guys please help me. why I am getting this error.. Is there something wrong in my query?

这是错误..

#1064 - 您的 SQL 语法有错误；检查与您的 MySQL 服务器版本相对应的手册以了解要使用的正确语法在第 7 行的LIMIT 0, 25"附近

#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 'LIMIT 0, 25' at line 7

这是我的查询:

SELECT
    equivalent
FROM
    tb_student_record
INNER JOIN
    tb_student ON tb_student_record.stud_id = tb_student.stud_id 
WHERE
    tb_student_record.instructor_id = 'INST-20131296' 
    AND tb_student_record.criteria_id = '1' 
    AND tb_student_record.class_record_id = '1' 
    AND (CONCAT(stud_fname, ' ', stud_lname) = 'Jeffrey Oliveras' 
    AND tb_student_record.term = 'Prelim'

推荐答案

concat 函数中缺少右括号

SELECT equivalent FROM tb_student_record INNER JOIN tb_student ON tb_student_record.stud_id=tb_student.stud_id 
WHERE tb_student_record.instructor_id = 'INST-20131296' 
AND tb_student_record.criteria_id = '1' 
AND tb_student_record.class_record_id = '1' 
AND (CONCAT(stud_fname, ' ', stud_lname) = 'Jeffrey Oliveras' )
AND tb_student_record.term = 'Prelim'

这篇关于MySQL:SQL 语法错误 |限制 0, 25的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！