随笔分类 - Z.MySQL.查询数据
摘要:代码: select t1.descid, IFNULL(t2.cnt,0) as countnew, t1.description from uosdesc t1 left outer join t2 on t1.descid=t2.descid order by countnew desc 说明
阅读全文
摘要:在MySQL中有个特殊的规定,即不允许使用列别名作为查询条件。比如有下面一个表: select ID, title, concept, conceptLength, addUserId, modifyTimefrom collections_wisdom 将SQL修改如下: select ID+1
阅读全文