Mr_ZhangAdd的博客

SELECT SUM(paid) AS sumCostPrice, DATE_FORMAT(createTime, '%Y-%m') AS createTimeFormate FROM `t_procurement_new` WHERE companyId = 39 AND createTime >= "2021-01-01" AND createTime <= "2021-12-01" GROUP BY createTimeFormate UNIONALL.

SELECT * FROM table_A where name= BINARY #{name}

UPDATE `表名`SET `字段名` = CONCAT(`字段名称`, '追加内容')

1.修改数据库字符集，把utf-8改为gbk。2.修改sql语句：把select * from user order by name desc 改为 select * from user order by convert(name using gbk) desc转载：https://blog.youkuaiyun.com/wxhcr912/article/details/78123121

使用dos命令修改：之前我安装好mysql8，然后使用sqlYong登陆发现提示密码已经过期，然后我使用dos命令登陆发现却可以登陆上去，欣喜万分（因为此前我已经卸载安装大约10几次了）然后我cd到根目录  使用mysql -u root -p 然后输入密码1、 修改用户密码【我之前使用很多很多种命令修改密码，却唯独这个有用】mysql&gt; alter user 'root'@'lo...

将serverTimezone的配置改为Asia/Shanghaiurl: jdbc:mysql://47.100.245.18:3306/bfc?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&zeroDateTimeBehavior=convertToNull&useS...

日 SELECT DATE_FORMAT(create_date,'%Y-%m-%d') AS times , COUNT(*) AS COUNT FROM  表名  b WHERE b.`create_date` &lt;= "2019-02-09 00:00:00" AND b.`create_date` &gt;= "2019-02-07 00:00:00"GROUP BY  tim...

这个异常是数据库时区的异常Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configu...

Window：在my.ini文件中添加 （注意位置不能错，我的数据库版本是8.0，版本之间可能会有差异，不过大同小异自行百度）sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION...