Question

静态化sql语句执行错误，怎么解决

SQL语句执行错误: SELECT COUNT(*) AS total FROM emlog_blog WHERE type='blog' and hide='n' and gid IN (,9,10,11,12,13,14,15,16,17,19,20,21,22,23,25,26,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,44,45,46,47,48,49,50,51,52,53,54,55,56,57,59,62,64,65,66,67,68,70,71,72,73,74,75,76,78,79,80,81,82,83,84,86,87,8) order by date desc
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 '9,10,11,12,13,14,15,16,17,19,20,21,22,23,25,26,28,29,30,31,32,33,34,35,36,37,38,' at line 1
«点击返回

Answer 1

语句中in子句后面的括号里的 第一个常量“9”的前面多了一个逗号，务必将其删除。

追答

另外语句只会返回一行记录，order by子句毫无必要，也要除掉。

Answer 2

,9？
你第一个9哪里不用加“，”的