摘要:
1.大概思路,docker 新启一个mysql5.7 端口映射到3307 2. 导出5.5 的.sql文件,导入5.7中 3.测试通过后,可将5.5关闭。5.7端口改回3306 GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "**"; 坑 阅读全文
摘要:
按年汇总,统计: select sum(mymoney) as totalmoney, count(*) as sheets from mytable group by date_format(col, '%Y'); 按月汇总,统计: select sum(mymoney) as totalmone 阅读全文