SQL语句错误： select wkcx_content.news_title,wkcx_content.id,wkcx_content.news_order,wkcx_content.tuijian,wkcx_content.add_time,wkcx_class.id as cat_id,wkcx_class.class_name,wkcx_content.counter from wkcx_content,wkcx_class where cat_id = 1247 AND wkcx_class.id = wkcx_content.cat_id and wkcx_content.type != 3 and wkcx_content.add_time>'2020-12-31'
union
select wkcx_content.news_title,wkcx_content.id,wkcx_content.news_order,wkcx_content.tuijian,wkcx_content.add_time,wkcx_class.id as cat_id,wkcx_class.class_name,wkcx_content.counter from wkcx_content,wkcx_class where wkcx_content.cat_id IN(select wkcx_class.id from wkcx_class WHERE pid = 1247) AND wkcx_class.id = wkcx_content.cat_id and wkcx_content.type != 3 and wkcx_content.add_time>'2020-12-31' ORDER BY add_time DESC ,id DESC,news_order asc limit -22,22 错误信息： 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 '-22,22' at line 3
新浪微博
腾讯微博
陕公网安备 61052602000006号