SQL语句错误,小白请大佬帮分析详细指导

apptle2 发布于 03/06 14:09
阅读 148
收藏 0

ERR: 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 ')   ORDER BY refreshtime DESC  LIMIT 5' at line 1
 [ SQL语句 ] : SELECT `id`,`fullname`,`sex`,refreshtime  as time,'refresh' as type FROM `qs_resume` WHERE `display` = 1 AND `audit` = 1 AND `id` NOT IN ()   ORDER BY refreshtime DESC  LIMIT 5

请大佬帮看看,改怎么改。

加载中
0
河岸飞流
河岸飞流

not in 没塞条件值

0
javaxiaoz
javaxiaoz

AND `id` NOT IN ()  你没有放参数啊

可以过滤下语句的条件,如果`id`是空的,那么就不加这个条件就可以了

0
一只慢慢爬的小蜗牛
一只慢慢爬的小蜗牛
in后面的参数不能为空呀
返回顶部
顶部