随笔分类 -  让你少走些弯路 - mssql/mysql篇

常遇问题及方法
mysql取前取后
摘要：SELECT * FROM (SELECT * FROM 表 WHERE id=居中的IDORDER BY id ASC LIMIT 5) as Border by id asc 阅读全文
posted @ 2014-05-16 13:21 mali0932 阅读(143) 评论(0) 推荐(0)
mysql 按距离今日时间最近排序
摘要：xxxorder by abs(DATEDIFF(time_start,now())) 阅读全文
posted @ 2014-01-11 13:30 mali0932 阅读(691) 评论(0) 推荐(0)