wen2034的专栏

select  mi.*,mc.coinNum,mc.ticketNum from memberinfo mi, membericcard mc where mc.miid = mi.miid  select  mi.* from memberinfo mi, membericcard mc where mc.miid = mi.miid

先定义一个比较日期，如果周开始为周日，那么这天必须为周日，如‘2014-03-23’ select date_add('2014-03-23',interval datediff(date,'2014-03-23') div 7*7 day) as week_start, date_add('2014-03-23',interval datediff(date,'2014-03-

innodb_buffer_pool_size=1024M //缓存innodb表的索引,查询结果集大时效果明显