我自己写的一个SQL语句，大家看看错在哪
select *from t_quesword as model where model.answerstate=0 order by model.FAQstate DESC, model.asktime DESC;
[解决办法]
少了空格，其余的自己检查字段名称：
select * from t_quesword as model where model.answerstate=0 order by model.FAQstate DESC, model.asktime DESC;
[解决办法]
根据你的 sql语句
个人的mysql
SELECT * FROM cstm_company AS model WHERE model.CR_CITY_ID='891' ORDER BY model.CN_COMPANY_STATUS DESC,model.CN_ADDRESS DESC;
没有任何问题
[解决办法]
model好像是关键字
[解决办法]
去掉as就行了
[解决办法]
应该没问题的，试试就知道了，给点分吧
[解决办法]
