查询时order by要写在where后面,否则会报错
正确写法:select * from message where readTag = 0 order by createTime desc;
错误写法:select * from message order by createTime desc where readTag = 0 ;
sql注意,布布扣,bubuko.com
sql注意
原文:http://blog.csdn.net/sprita1/article/details/20733841