摘要:
select distinct( DATE_FORMAT(send_time,'%Y-%m-%d') ) as consultation_date from text_message a where a.type=1 and a.category=1 and ((a.sender_id=6228841891912220677 and a.receiver_id=6227763200226... 阅读全文
摘要:
select c.item_id, c.type as item_type, c.item_name , floor(c.item_price) as item_price, c.item_unit, c.state as item_state_code, case c.state when 0 t 阅读全文
摘要:
select c.name, a.measure_item_code, max(measure_time) from measure_rec a left join measure_item c on a.measure_item_code = c.measure_item_code where a 阅读全文
摘要:
http://www.jb51.net/article/31868.htm 以下分享一点我的经验 一般刚开始学SQL的时候,会这样写 复制代码 代码如下: SELECT * FROM table ORDER BY id LIMIT 1000, 10; 但在数据达到百万级的时候,这样写会慢死 复制代码 阅读全文
摘要:
http://www.cnblogs.com/beijingstruggle/p/5631603.html mysql的sql分页函数limit使用 My sql数据库最简单,是利用mysql的LIMIT函数,LIMIT [offset,] rows从数据库表中M条记录开始检索N条记录的语句为: S 阅读全文