- 把三列数据合并成一行
SELECT CONCAT(addr_province,addr_city,addr_county) as address from table_a;
- 统计每天的销售额
SELECT SUM(amount), DATE_FORMAT(create_time,'%Y-%m-%d') dat FROM table_a GROUP BY DATE_FORMAT(create_time,'%Y-%m-%d');
3.
4.
5. mysql日期相关
6.Union用法