按时间查询数据（时间存储的格式是unix时间戳） 无 select *from `pre_common_member_log_w`where date_format( from_unixtime( dateline ) , '%y-%m-%d' ) = date_format( now( ) , '%y-%m-%d' )limit 0 , 30select *from `pre_common_member_log_w`where da
按时间查询数据（时间存储的格式是unix时间戳） select *from `pre_common_member_log_w`where date_format( from_unixtime( dateline ) , '%y-%m-%d' ) = date_format( now( ) , '%y-%m-%d' )limit 0 , 30select *from `pre_common_member_log_w`where date_format( from_unixtime( dateline ) , '%y-%m-%d' ) = '2014-10-23'limit 0 , 30select date_format( from_unixtime( dateline ) , '%y-%m-%d' ) as mytime, titlefrom `pre_common_member_log_w`where date_format( from_unixtime( dateline ) , '%y-%m-%d' ) = '2014-10-23'limit 0 , 30