是不是IN语句 *** 了in子句参数的数目?而且不能全部查出来,不知道怎么回事?
改一下
SELECT id,headline,date_added FROM ag_news WHERE cate_id IN ( 2,69,72,71,70,10,57,54,53,9,18,17,8,52,16,15,14,7,48,13,12,11 ) ORDER BY date_added DESC
SELECT id,headline,date_added FROM ag_news WHERE cate_id IN ('2,69,72,71,70,10,57,54,53,9,18,17,8,52,16,15,14,7,48,13,12,11 ) ORDER BY date_added DESC
不要那个单引号
SELECT id,headline,date_added FROM ag_news WHERE cate_id IN ('2,69,72,71,70,10,57,54,53,9,18,17,8,52,16,15,14,7,48,13,12,11 ) ORDER BY date_added DESC
| 论坛热门帖子: | [lch203] 写得蛮好的linux学习笔记(10-21) [黑马制造] 学习java的30个目标(10-19) [笑傲股林] 做测试半年了,有点迷茫,应该再学些什么提高自己的测试水平和测试能力呢?(10-19) [udp8589] 大家用google的来吱一声? 用百度的~~也来报道下?(10-18) [沂偌掳兆] 本人总结的一些认为C++比较经典的书籍,希望对大家有用(10-18) |
| TAG标签: | 正确 结果 怎么 语句 这个 date_added IN BY DESC SELECT |
注册
个人空间
