your MySQL server version for the right syntax to use near 'NULL' at line 1

dwsMo2

于 2016-12-20 20:52:25 发布

阅读量1.3w

点赞数

CC 4.0 BY-SA版权

文章标签： mysql

本文链接：https://blog.youkuaiyun.com/dwsMo2/article/details/53769155

本文介绍了如何解决在执行SQL语句时遇到的MySQL语法错误，提示'NULL'在第1行附近有误。通过检查MySQL服务器版本和手动修正语法，可以找到问题的解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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 ‘NULL’ at line 1

    今天使用mysql事件执行一段程序,  
    set @deletesql =CONCAT('DELETE from classuserorder',' where a=',a);
    PREPARE stmt FROM @deletesql;
    EXECUTE stmt ; 
    DEALLOCATE PREPARE stmt;
    老是报异常,看错误应该是sql中有null,应该是concat拼接null后结果@deletesql为null,导致报错,对参数a做下判断即可