20171016

SELECT LEFT(日期,4),RIGHT(LEFT(日期,6),2),RIGHT(日期,2),日期, 时间,SUM(地铁入口),SUM(商场东门),SUM(商场正门),SUM(手扶梯),SUM(停车场入口),SUM(西树走道),SUM(总汇入口),SUM(合计) FROM bh_time JOIN bh_visitors_flowdate ON bh_visitors_flowdate.id=bh_time.id GROUP BY LEFT(bh_time.`time`,10)
SELECT id,(日期,'',时间)FROM bh_visitors_flowdate;
SELECT * FROM bh_time JOIN bh_visitors_flowdate ON bh_visitors_flowdate.id=bh_time.id GROUP BY LEFT(bh_time.`time`,10);
GROUP BY bh_time.`日期+时间`

SELECT LEFT(TIME,10) FROM bh_time
SELECT CONCAT(YEAR,'-',mon,'-',DAY),时间,地铁入口,商场东门,商场正门,手扶梯,停车场入口,西树走道,总汇入口,合计 FROM baihua_data;
SELECT WEEKDAY(date_time),date_time,时间,地铁入口,商场东门,商场正门,手扶梯,停车场入口,西树走道,总汇入口,合计 FROM renliu_data;
SELECT SUM(商场正门),周几 ,时间 FROM renliushuju WHERE 周几=0 AND 年月 BETWEEN '2017-04-20' AND '2017-05-10' GROUP BY 时间 ;