mysql
郝小祺
初级博客,很希望交到一些一起成长的盆友们
展开
-
canal mysql数据同步mysql
mysql 数据同步mysql 多表同步需要创建多个rdb/yml文件原创 2022-06-07 13:59:11 · 2501 阅读 · 0 评论 -
mysql 时间差统计
mysql 时间统计,多个重叠时间统计出总运行时间原创 2022-05-05 13:21:56 · 633 阅读 · 0 评论 -
wps excel连接MySQL数据库可刷新实时读取数据
1. 先确定是否下载mysql驱动https://dev.mysql.com/downloads/connector/odbc/原创 2021-06-18 10:10:24 · 9084 阅读 · 7 评论 -
linux ubnutu mysql which is not functionally dependent on columns in GROUP BY clause; this is incom
linux ubnutu 找到/etc/mysql/my.cnf 发现转到my.cnf -> /etc/alternatives/my.cnfvi/etc/alternatives/my.cnf 添加:[mysqld]sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION如...原创 2021-05-25 11:50:21 · 373 阅读 · 0 评论 -
查询当前时间前60秒的数据
create_time > NOW() - interval 60 second // 时间 > 当前时间 - 60秒原创 2021-01-05 13:43:12 · 769 阅读 · 0 评论 -
完美解决(报错 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated)
很简单的东西我整复杂了, 我的是因为mysql没有走my.ini放一下我的my.ini[mysqld]character-set-server=utf8#绑定IPv4和3306端口bind-address = 0.0.0.0port = 3306sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"default_storage_engine=innodbinnodb_buffer_pool_size=1000Minnodb_l.原创 2020-09-15 11:41:51 · 1435 阅读 · 0 评论 -
springBoot中mybatis事务使用方法
1.在SpringBoot中mybatis-plus-boot-starter 或mybatis-spring-boot-starter 会自动定义好事物,在pom.xml中导入jar2.在Application(启动类)中添加注解@EnableTransactionManagement3.在需要回滚的方法或类上添加注解@Transactional//下面是测试效果 执行...原创 2020-03-20 14:02:22 · 869 阅读 · 0 评论 -
ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROF
ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROF:错误是从这里开始的,我百度了一下,有两种解决办法1. 打开mysql查询命令输入 select version(), @@sql_mode;//这个是查看你配置的SET sql_mod...原创 2020-01-03 11:29:56 · 1108 阅读 · 1 评论