dushan1234的专栏

今天有一个项目在测试环境报错，框架是SpringCloud,数据库用的是腾讯云的数据库 报错的日志信息如下（去除公司信息）： ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 12,026,089 milliseconds ago. The last.

查询每天的数据： SELECT COUNT(1) AS countNumber, DATE_FORMAT(createTime,’%Y-%m-%d’) AS dateTime FROM testTable GROUP BY DATE_FORMAT(createTime,’%Y-%m-%d’); 查询每周的数据： SELECT COUNT(1) AS countNumber, WEEK(cre...